Forum Discussion
DAX Divide function
I want to divide, Count(items.length) / workingDays. { Count(item.length) = count of different product, and Working days = No. of days betwwen two selected dates } for that I wrote DAX function Mea...
I want DAX formula for Divide,
it's like, Measure = No. of product / (no. of days between two dates - 1 - No. of Sundays in selected period)
Measure =
COUNT('Production of the day'[productshortname]) / (VALUES ( 'Production of the day'[actualendtime] )- 1 - no. of sundays)
how should i write Correct fromula for this.
Here is context of each term,
No. of product = COUNT('Production of the day'[productshortname]),
no. of days between two selected dates = (VALUES ( 'Production of the day'[actualendtime] ),
1 = totals selected no. of days minus 1 day ( 10 -1=9; 10 - totals selected no. of days between dates ),
No. of Sundays in selected period = no. of sundays( how should i write DAX for no. of Sundays between selected date only)