Forum Discussion
Helper IDynamic Fiscal Year
They've also recently released custom templates:
https://www.sqlbi.com/articles/customizing-date-and-time-intelligence-templates-in-bravo-for-power-bi/sam_hoccane, I'd strongly recommend using a date table.
https://radacad.com/do-you-need-a-date-dimensionOne way to define your fiscal quarter:
ROUNDDOWN ( MOD ( MONTH ( [Date] ) + 1 , 12 ) / 3, 0 ) + 1
Super UserHi sam_hoccane ,
I would recommend using a date table like the one below which you can adjust to fit your fiscal calendar:
https://www.sqlbi.com/articles/reference-date-table-in-dax-and-power-bi/
Super UserThey've also recently released custom templates:
https://www.sqlbi.com/articles/customizing-date-and-time-intelligence-templates-in-bravo-for-power-bi/
sam_hoccane, I'd strongly recommend using a date table.
https://radacad.com/do-you-need-a-date-dimension
One way to define your fiscal quarter:
ROUNDDOWN ( MOD ( MONTH ( [Date] ) + 1 , 12 ) / 3, 0 ) + 1
sam_hoccaneThankyou all!