Forum Discussion

Dhamu_114's avatar
Dhamu_114
New Member
8 years ago

DateDiff and Date Slicer

Hi, I am working in equipment utilization report. I need to calculate total number of dates btw my date column, based on the date slicer. So used Datediff as measure And utilization per day is Total hours / No. of days, where Total hours is Column and No. of Days is measure. Hence cannot use datediff measure in denominator. The utilization comes as infinity. Really helpful if someone gives valuable ideas.

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support

    Hi Dhamu_114,

     

    Which columns are measure  No. of days based on? Could you please give me some DAX formula and sample data about your measure?

     

    Regards,

    Jimmy Tao