Forum Discussion

Boycie92's avatar
Boycie92
Icon for Resolver I rankResolver 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
Boycie92's avatar
Boycie92
Icon for Resolver I rankResolver I
5 years ago

HI lbendlin 

 

I have somthing simialr built into the M code:     CurrentDateRecord = Table.SelectRows(AddFY, each ([Date] = CurrentDate))

 

Would that not work?

 

If it has to be a caculated column then I would be ok with that.

 

what formual would I need to use for it?

 

Thanks,

Boycie92

lbendlin's avatar
lbendlin
Icon for Super User rankSuper 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
    Icon for Resolver I rankResolver 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
      Icon for Super User rankSuper User
      5 years ago

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

      • Boycie92's avatar
        Boycie92
        Icon for Resolver I rankResolver I
        5 years ago

        Hi lbendlin 

         

        It starts in April.

         

        Thanks,

        Boycie92