Converting Excel to Power BI

[Sar33]

Hello all,

I come to ask in this forum your to find a solution to the adaptation of an excel follow-up of follow-up maintenance of hardware.

The principle is to visualize in graphical form, the downtime between shutdown and back in service of the product.

In addition, we need to be able to know by day/week/month the number of devices shut down and the number in service.

Taking into account the accumulation from day to day/week/month.

I'd like to be able to adapt this calculation in DAX to make it more flexible, with automatically fed dynamic graphs.

Thank you in advance for any help on this subject.

[Sar33]

First of all, thank you for your help and involvement in this matter.

I have used the files you shared in your response, but I have noticed some discrepancies compared to the expected results.
Indeed, the chart returns data that does not match my initial table (see the screenshot). I have added certain elements for better understanding.
Here are a few examples:
- Week 1: 4 OFF
- Week 2: 4 OFF
- Week 3: 2 OFF

I would like to have a filter on the chart to select specific periods (day/month/year).

If you have the opportunity to work on the file again, I would be greatly appreciative.

[mickey64]

Step 0: I use these data below.

Step 1: I make a 'Calendar' table.

Step 2: I don't add a relationship.

Step 3: I make a measure.

M_OFF = COUNTROWS(FILTER(ALL('DATA'),'DATA'[BIS DATE]>=MIN('Calendar'[Date])&&'DATA'[STOP DATE]<=MIN('Calendar'[Date])))

Step 4: I make a graph.