Forum Discussion

Boycie92's avatar
Boycie92
Resolver I
5 years ago

Power Query Date Table: Current 6 Months

Hi,   I am hoping someone can help.   I have created a date table in Power Query using the following code:   let fnDateTable = (StartDate as date, EndDate as date, optional FYStartMonthNum as n...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
lbendlin's avatar
lbendlin
Super User
5 years ago

Doing it in M code is the same (sort of) as doing it in a calculated column. It is only computed once during the dataset refresh.  If you do not refresh your dataset frequently then the meaning of "CurrentDate"  will get skewed as you move on from the date when the dataset was last refreshed.

 

So yes, your approach would work, but it would not be dynamic.

Boycie92's avatar
Boycie92
Resolver I
5 years ago

Hilbendlin,

 

 My dataset would be getting refreshed everyday. So I am not concenred about that. I am just confused as to how I can build that flag in and get it to work the way I want.

 

Thanks,

Boycie92

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    When does your fiscal year start, in April or October?

    • Boycie92's avatar
      Boycie92
      Resolver I
      5 years ago

      Hi lbendlin 

       

      It starts in April.

       

      Thanks,

      Boycie92