I like to Count of Machine that are active in a time periode. I have a start date, and stop date, and i use a calender table. Th Count of items can be for each day, week, month, year.
I have a shrepoint teble With “machines”, and a table With “Activity” With machine name, start and stop date.
Example: Start Stop
Machine A 1. january 31. march
Machine B 5. january 15. february
Machine C 20. february 28. march
Machine D 1. april 30. april
When i use pr week in the calendar tape, i lake to se how many machines that was active in this actual day, week og month. If the time of calculation is between the stop and start date, it should be counted.
Jan Feb March April
Machine A 1 1 1 0
Machine B 1 1 0 0
Machine C 0 1 1 0
Machine D 0 0 0 1
Any idea how the DAX formula should look like. Thank You :-).