Forum Discussion

Atch's avatar
Atch
New Member
2 years ago

Date dax

 please anyone help with this dax      amitchandak 
"Date Table"
Date
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Atch 

 

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.

How to Get Your Question Answered Quickly - Page 13 - Microsoft Fabric Community

 

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.

Atchaya-Prabhu's avatar
Atchaya-Prabhu
New Member
2 years ago

 I have no option to attach it,
Date formula

DateTable = CALENDAR(DATE(2022,08,01), TODAY())

Weekend date formula

Weekend Date = [Date] + 6 - WEEKDAY([Date], 2)

Fiscal year formula

Fiscal Year = IF(MONTH([Date]) >= 8, YEAR([Date]) + 1, YEAR([Date]))

date 1 formula

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

 

Using date 1 column as a slicer in the visual

Here you see date from 8/5/2023 to 8/3/2024 but i want to see till latest weekend date for example till  02/03/2024 , whwenever it refreshes it has to show  recent weekend date only like  tomorrow it refreshes to see 2/10/2024, in my case it shows everything till 8/3/2024..

When date 1 column sorts descending it has to show from initial date  08/05/2023 to till latest weekend date i hope this helps.. i have no option to attach my pbi file...

i have 2 accounts so replied in different account.kindly help