Forum Discussion

aAmirkHan's avatar
aAmirkHan
Icon for Helper III rankHelper III
3 years ago
Solved

Dynamic Date Table in Power BI

Hi Power BI Expert,   I have a date table in Power BI by using the Calculated Table. I get files daily in a folder and I manually change the date in Power BI daily.   For the example, I created a...
Show and Tell
Tips and Tricks
Tutorial Requests
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    pls try this

     

    let
    Source = List.Generate(()=>#date(2021,4,1),(x)=>x<=Date.From( DateTime.LocalNow()),(x)=>Date.AddDays(x,1)),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), {"Date"}, null, ExtraValues.Error)
in
    #"Converted to Table"

     

    Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

    https://1drv.ms/u/s!AiUZ0Ws7G26RiioNEvq6napYAxiV?e=FIx55g

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

pls try this

 

let
    Source = List.Generate(()=>#date(2021,4,1),(x)=>x<=Date.From( DateTime.LocalNow()),(x)=>Date.AddDays(x,1)),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), {"Date"}, null, ExtraValues.Error)
in
    #"Converted to Table"

 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

https://1drv.ms/u/s!AiUZ0Ws7G26RiioNEvq6napYAxiV?e=FIx55g