Duplicate Time intelligence measures

[Blaise880]

Hi guys, 

I have a problem which I am not sure how to fix in a quick way.

I've got to recreate an excel report that looks like this.

For each of the dimensions (Act, LW, LY, 2019, v Plan, WoW, v LY ,v 2019) I have to rewrite the measure only changing the time intelligence filter.

I did some googling and a solution would to be to use calculation groups in Tabular editor, however the problem is that for some of the measures the calculation is different or there is different data source.

Any help would be greatly appreciated.

[Greg_Deckler · Accepted solution]

@Blaise880 One way would be to use a disconnected table and a single measure that determines which value to display. This measure can reference other measures. This is a pretty common technique. You might also be able to use multiple measures but use the "Show on rows" feature of a matrix. The disconnected table in this case would be for the columns. Not really enough information to be super detailed. You might take a look at these resources for time intelligence functionality.

You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

Also: