Table visual with MoM measure only for last month

[pkalisz]

I'm trying to create a table/matrix visual where given data, I add a column that is MoM comparison, but only for the last month.

Given a Dummy table, I'd like my visual to present like that in April:

Dummy table in April:

The month before, upon no data of April, the visual would look like below:

I am able to create MoM measure for all months, and even only for the latest month, using methods similar to presented here.

The problem is that when I use that as a measure, in the best case, I can only get an empty MoM column for previous months. The goal is to have MoM column only at the end, and only for the most recent period.

[Greg_Deckler · Accepted solution]

@pkalisz The New Hotness (Custom Matrix Hierarchy) - Microsoft Power BI Community

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[pkalisz]

This one is super easy and intuitive. Thank you so much.

[Ashish_Mathur]

You are welcome.

[Greg_Deckler · Accepted solution]

@pkalisz The New Hotness (Custom Matrix Hierarchy) - Microsoft Power BI Community

[pkalisz]

Wow, that's a great and fast response, thank you!

Can I do custom hierarchy dynamically, so it doesn't need a manual update?