Forum Discussion
Lenastray
Helper I
Helper IPrevious dates using date add and switch
Hi, Thanks in advance for the support. The objective is to make a measure that gives the previous aummount for any date, excluding holidays and weekends. I was using the "is holiday" and "is week...
Of course you get an error because SWITCH cannot return a table and tables and tables only can be filters in CALCULATE. Also, calling field names without wrapping them into an aggregation function when there's no row context must lead to errors.
Please try to read something about CALCULATE and how filters work in DAX.
By the way, your case is not clear at all. Please explain in detail what you want to do and then someone will certainly be able to help you.
Best
D
Please try to read something about CALCULATE and how filters work in DAX.
By the way, your case is not clear at all. Please explain in detail what you want to do and then someone will certainly be able to help you.
Best
D