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

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