Forum Discussion
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 dow...
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.