I realized that the "Quarter" column can also be created using <"Quarter",QUARTER([Date]),>. May I ask if it is the same as <"Quarter",FORMAT([Date],"Q"),>? Will it make any difference later on when create visuals/measures etc?

it is not, QUARTER function on its own will give you the quarter as in number - 1,2,3,4 so Power BI will recognize them as int rather than a string, because you want to be able to filter by the Quarter. When used inside the FORMAT function the integer becomes a string because it concatenates Q with the quarter number

Follow this topic

Jonathan Chng Lin Feng

Last answered:

10 Dec 2021

Posted on:

10 Dec 2021

Is "Quarter",QUARTER([Date]) same as "Quarter",FORMAT([Date],"Q")?

in Power BI / Hierarchies

1 answers ( 0 marked as helpful)

Dimitar Shutev

Posted on:

10 Dec 2021

Is "Quarter",QUARTER([Date]) same as "Quarter",FORMAT([Date],"Q")?

Submit an answer

related questions