Creating Dates Financial Quarters

[Anonymous]

HI i am building out the below code and was wondering how i can add FY Quarters to the code aswell?

[v-kelly-msft]

Hi @Anonymous ,

Check the 2 funtions below:

https://docs.microsoft.com/en-us/powerquery-m/date-addquarters

https://docs.microsoft.com/en-us/powerquery-m/date-quarterofyear

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Anonymous , Power Query I am not sure.

In DAX it

FY QTR = Quotient(datediff([FY Start Date], [Date], Month),3)+1