Forum Discussion
Solved
YEAR DAX NOT WORKING AS EXPECTED
Hello, I've a date column (PeriodFormatted) which I'm using as a filter for a report. Based on the selected month, I want to calculate value of a particular column for that YEAR to which the mont...
The answer realy depends on your data, but here are some solutions :
Using a KEEPFILTERS allows you to keep some of them.
Or maybe you can just remove the month filter ?
In that case it will be
Total Global= CALCULATE([Global Sales],ALL(DateTable[Month])) instead of ALL(DateTable[Year-Month])Tell us if it works
The answer realy depends on your data, but here are some solutions :
Using a KEEPFILTERS allows you to keep some of them.
Or maybe you can just remove the month filter ?
In that case it will be
Total Global= CALCULATE([Global Sales],
ALL(DateTable[Month])) instead of ALL(DateTable[Year-Month])
Tell us if it works
Hi AilleryO,
This worked. Thanks a lot :).
Regards,
RB