Forum Discussion

New Member

2 years ago

Date dax

please anyone help with this dax amitchandak

Anonymous

Not applicable

2 years ago

I try the same measure in my side, but no error.

Could you please share your data(without sensitive data), or create a set of sample data.

And describe the target you want in detail, so that we can help you better.

^{Best Regards,}

^{Zhengdong Xu}

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

New Member

2 years ago

I have sensitive data

but I can explain more

I have date column from 8/1/2022 to till today 2/9/2024 , fiscal weekend column which only weekend dates of 8/1/2022 to 2/9/2024

i have another date column using the Dax

IF(FiscalDateTable[Fiscal Year]=MAX(FiscalDateTable[Fiscal Year])-1,FiscalDateTable[Weekend Date]+364,FiscalDateTable[Weekend Date])

Im using this date in date slicer so when I slice it has to show 2022 weekend date data , also 2023 weekend date data

but it showing future weekend date also like this