Forum Discussion

Jan1984's avatar
Jan1984
New Member
4 years ago

Rolling DateTime Calulation

Hello All,   I am Receiving a daily rolling 10 Days Extract every day, where I need to modify the provided Date Column. Therefore I created an example Dataset with only the Date Column(File -->htt...
DAX
DAX Date condition
Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

Jan1984 Maybe:

let
    Source = fnDateTable(#date(2020,1,1), #date(2022,12,31)),
    #"Filtered Rows" = Table.SelectRows(Source, each Date.IsInPreviousNDays([Date], 10))
in
    #"Filtered Rows"
Jan1984's avatar
Jan1984
New Member
4 years ago

Hello,

Thanks a lot for you reply, unfortuanatly the provided idea is not exactly what i am looking for because my rolling every day rawdata will show the prev. 10 days anyway so your filtering solution would be obsolete.

 

I rather try to create an additional Date column where i am grouping the existing Dates based on the above provided criterias.