Forum Discussion

Sar33's avatar
Sar33
New Member
2 years ago

Converting Excel to Power BI

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.

 

Need Help

2 Replies

  • mickey64's avatar
    mickey64
    Super User
    2 years ago

    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.

     

  • Sar33's avatar
    Sar33
    New Member
    2 years ago

    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.