Time date Matrix with extra column

[Jlbaenlo]

Hi,

I'm struggling building a custom matrix.

I have a matrix with time in column, and I would like to have extra columns besides like, a total but also an custom average for a portion of the time (like the last 3 months average) and another measure (Target) which depends from the products but not the time, and then a delta between the last3month Avg and the target

     Oct2020 Nov2020 Dec2020 Jan2021 Fev2021 Total. Last3MAvg   Target    Delta

p1   10.        20.            20.          30.         10.          90.      20.              15.           5

p2

p3

how shall I do this ?

many thanks in advance for your help,

JL

[amitchandak]

@Jlbaenlo , Hybrid display is not possible you have to use one of the suggested approaches. Either use all columns or make dynamic columns including these columns too.

Vote for the idea

https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc

[PaulDBrown]

@Jlbaenlo 

Check out this thread in which a similar request is being explored:

Creating custom matrix with extra columns 

Here's one example of how it can be done:

[Greg_Deckler]

@Jlbaenlo - I created a method for doing this here: https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...