Forum Discussion

Tripb44's avatar
Tripb44
Icon for Helper II rankHelper II
5 years ago
Solved

Apply current working days left to future months value

I need to apply the current working days left in the current month to future months.  For example, below I would need to apply the working days left in March multiplied by the order backlog per day i...
Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi Tripb44

     

    Try measure as:

    workday left days in current month = 
var a=CALCULATE(
    COUNT('Calendar'[Date]),
    FILTER(
        'Calendar',
        WEEKDAY('Calendar'[Date])>=1 && WEEKDAY('Calendar'[Date])<=6 && 'Calendar'[Date]<=TODAY() && MONTH('Calendar'[Date])=MONTH(MAX('Table'[Month])
    )
)
)
return
MAX('Table'[working days])-a
    Measure = 
[workday left days in current month]*MAX('Table'[order backlog per day])

     Here is the output:

    I'm not sure of your logic for calculating workdays, if you need to modify dax, please provide details.

    The pbix file is attached.

     

    Best Regards,

    Link

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

v-xulin-mstf's avatar
v-xulin-mstf
Icon for Community Support rankCommunity Support
5 years ago

Hi Tripb44

 

Try measure as:

workday left days in current month = 
var a=CALCULATE(
    COUNT('Calendar'[Date]),
    FILTER(
        'Calendar',
        WEEKDAY('Calendar'[Date])>=1 && WEEKDAY('Calendar'[Date])<=6 && 'Calendar'[Date]<=TODAY() && MONTH('Calendar'[Date])=MONTH(MAX('Table'[Month])
    )
)
)
return
MAX('Table'[working days])-a
Measure = 
[workday left days in current month]*MAX('Table'[order backlog per day])

 Here is the output:

I'm not sure of your logic for calculating workdays, if you need to modify dax, please provide details.

The pbix file is attached.

 

Best Regards,

Link

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.