Good day everybody,
I am facing a relatively trivial problem, but somehow I can not continue.
Aussprache lernen
I would like to know how (dax measure) many working days are still available in the current business month from today (in Excel/ Power Pivot).
I have the following table:
<tbody>
</tbody>
As you can see, the business month is different from the normal month.
I constantly receive only any error messages.
Does somebody has any idea?
Best Regards
I am facing a relatively trivial problem, but somehow I can not continue.
Aussprache lernen
I would like to know how (dax measure) many working days are still available in the current business month from today (in Excel/ Power Pivot).
I have the following table:
Date | B_Month | Workday |
01.01.2019 | Jan | 0 |
02.01.2019 | Dec | 1 |
<tbody>
</tbody>
As you can see, the business month is different from the normal month.
Code:
=VAR CurrentDay = MAX('Calendar'[Date])
VAR CurrentMonth = MAX('Calendar'[B_Month])
RETURN
CALCULATE('Calendar'[Workday];
FILTER(ALL('Calendar'[Date]); 'Calendar'[Date] <= CurrentDay &&
'Calendar'[B_Month] = CurrentMonth))
I constantly receive only any error messages.
Does somebody has any idea?
Best Regards