Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Help with Dynamic DAX Measure

Imagine a data set where there are multiple work dates, multiple employees on each work date, and multiple tasks performed by each employee on each work date.   How can I create a DYNAMIC measure t...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi, I am so sorry I must have missed your last reply/solution.

    At the end, this is what I used:

     

    Total Work Mins = [Total Number of Employees]*480 (=8x60=No. of work mins in a day)*[Number of Weekdays Selected]

     

    where

    Number of Weekdays Selected = var MinDate = MIN(Date_Calendar[Date])
    var MaxDate = MAX(Date_Calendar[Date])
    return CALCULATE(DISTINCTCOUNT(Date_Calendar[Date]),'Date_Calendar'[Date]<MaxDate,'Date_Calendar'[Date]>=MinDate,Date_Calendar[IsWeekday]=1)

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , Date is either selected from the date table or you fact So the number of the day will be

 

Days = count(Date[Date])

Days = distinctcount(Table[Date])

 

If you need working days. Make sure you have date table with Working days Marked as 1

 

Day = Sum(Date[Working Day])

 

Refer this file for working days: https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi, I am so sorry I must have missed your last reply/solution.

At the end, this is what I used:

 

Total Work Mins = [Total Number of Employees]*480 (=8x60=No. of work mins in a day)*[Number of Weekdays Selected]

 

where

Number of Weekdays Selected = var MinDate = MIN(Date_Calendar[Date])
var MaxDate = MAX(Date_Calendar[Date])
return CALCULATE(DISTINCTCOUNT(Date_Calendar[Date]),'Date_Calendar'[Date]<MaxDate,'Date_Calendar'[Date]>=MinDate,Date_Calendar[IsWeekday]=1)