Forum Discussion
Help adding holidays to measure
Hello BI community, I am currently working on a measure that automatically calculates the variance of 2 days worth of financial data. So far it works but when a holiday comes along the measure doe...
v-yulgu-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous ,
Is there anything that i can add or do to make the table recognize the holidays.
How to recognize? Should holiday dates be shown in visual? If yes, how to calculate balance and variance for holiday? Are holiday dates listed in fact data table and their corresponding balance are empty? Or holiday dates will be skipped in fact data table?
Please provide more sample data containing holidays.
Regards,
Yuliana Gu
I need the Holiday dates to be skipped sorry i forgot to mention that. I have a seperate table with the holidays after creating a relationship between the tables i thought just filtering would work but unfortunately it did not.
This is the holiday table i am using