Forum Discussion
Dhamu_114
8 years agoNew Member
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
Community 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