topic Re: Date dax in DAX Commands and Tips

Date dax

Atch — Wed, 07 Feb 2024 21:39:17 GMT

please anyone help with this dax

amitchandak

Re: Date dax

Anonymous — Thu, 08 Feb 2024 02:44:46 GMT

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.}

Re: Date dax

Atch — Fri, 09 Feb 2024 16:58:16 GMT

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

Re: Date dax

Atchaya-Prabhu — Fri, 09 Feb 2024 17:39:07 GMT

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