Time date Matrix with extra column

Question

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&nbsp; &nbsp; &nbsp;Oct2020 Nov2020 Dec2020 Jan2021 Fev2021 Total. Last3MAvg &nbsp; Target &nbsp; &nbsp;Deltap1 &nbsp; 10. &nbsp; &nbsp; &nbsp; &nbsp;20. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30. &nbsp; &nbsp; &nbsp; &nbsp; 10. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;90. &nbsp; &nbsp; &nbsp;20. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5p2p3&nbsp;how shall I do this ?many thanks in advance for your help,JL

greg_deckler · Answer

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

pauldbrown · Answer

Jlbaenlo&nbsp;
Check out this thread in which a similar request is being explored:
Creating custom matrix with extra columns&nbsp;
&nbsp;
Here's one example of how it can be done:

&nbsp;

amitchandak · Answer

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
&nbsp;

Forum Discussion

Time date Matrix with extra column

3 Replies

Related content

Add extra column

Matrix Column Widths

include extra column - target

Matrix column based on other matrix columns

Matrix column not grouped