Group results of a measure that returns a date in a matrix visual.

[DanielThangaraj]

I have a measure that returns a date in power bi (Latest Period in the below screenshot). How do I group the results into repective month on a matrix visual, just like how we could have if we use a date column with expand and collapse icon? The output required is one row for each month, with an expand/collapse button that would show/hide the country list. Right now I do not get that option as it a measure and not a column from a date table.

[Ritaf1983 · Accepted solution]

Hi @DanielThangaraj 
If I understood you correctly and you want to use the latest period as a category on the matrix ( with hierarchy),
it should be a calculated column.

Measures can be used only as "values"

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly