Additional columns OR Icons on the latest month >> in a Matrix

[Anonymous]

I have a basic start schema where to my Fact table I have got few other Dimension tables attached. One of these dimension tables is DimDate. I have tested and all seems to be working correctly. 

I have created a matrix like below where I have my:

DateDimension (In Green) as Columns

Measure [Sales Growth] (In Orange) as Values

Values from other dimensions (in Blue).

Percentage growth of mobile phones:

Brand	Type	Model	Jan-23	Feb-23	Mar-23	Diff in 2 monhts	Trend Icon
Samsung	Brick	Galaxy S23	67%	23%	76%	53%	Up
Nokia	Flip	N90	45%	87%	23%	-64%	Down
Microsoft	Book	Surface	87%	29%	59%	30%	Up
Apple	Brick	iPhone 13	23%	98%	37%	-61%	Down

I have so far been able to creat the measuree "Diff in 2 months" =

VAR _MaxMonth = CALCULATE(MAX(DimDate[YearMonthNumber]), ALLSELECTED(DimDate))
VAR _LatestAct = 
CALCULATE([Sales Growth], 
    FILTER(DimDate, 
    DimDate[YearMonthNumber] = _MaxMonth)
)

VAR _PrevMaxMonth = CALCULATE(MAX(DimDate[YearMonthNumber]), ALLSELECTED(DimDate), DimDate[YearMonthNumber] < _MaxMonth)
VAR _PrevLatestAct = 
CALCULATE([Sales Growth], 
    FILTER(DimDate, 
    DimDate[YearMonthNumber] = _PrevMaxMonth)
)

VAR _diff = _LatestAct - _PrevLatestAct

RETURN
_diff 

How do I use the measure in the matrix? 

Once I have the firstcolumn added I think I sould be able to add the same column and then use Conditional Formating > Icons to get the KPI Icons. 

Now, I have two options:

OPTION 1:

I would like to have the columns (in Purple) aftert the dates:

Diff in 2 months: while gives me the difference between Mar 2023 and Feb 2023 

Trend Icon: A KPI icon instead of Up and Down.

OPTION 2:
If having those additional columns is not possible then I could just use the Conditional Formattting > ICONS on the lastest month. But I can't figute out how I can only show Icons working for the last month. What would have worked is if I could have a column right after the latest month which represents all the months then the Icons would have worked, I think.

[Greg_Deckler]

@Anonymous Can you post some sample data (raw data)?

[Anonymous]

Thanks for replying @Greg_Deckler but I have made an MVP of the solution and this not hte original data.

Could I mock something up for you? What was it that you needed to see from the raw data and I can try to mock it up, maybe?

[Greg_Deckler]

@Anonymous Yeah, if you have an MVP of the situation maybe just share out a link to the PBIX.

[Anonymous]

Hey @Greg_Deckler , have you seen the MVP and also an example by @lbendlin?

[Greg_Deckler]

@Anonymous I guess I just assumed @lbendlin had solved it. Is there an issue with what @lbendlin did?

[Anonymous]

Believe @lbendlin was replyign to you when you asked for a MVP.

Anyways, so the problem is that I need the "Trend Icon" column at the end and not for everymonth. Please refer to the MVP file.  This "Trend Icon" column ideally should dispaly the the Icon (Up or Down) depending on the results of hte valus of the last months. 

Please refer to the original post for a bit more detail.

[Anonymous]

Hi @Greg_Deckler 

I originally just mocked-up the result but now I have created an actual MVP.

Please have a look:

https://mega.nz/file/eUYgDD4K#1jHGZlcWEcVjRCssIDjNnz0y_nicPO3x_4d9kfJZfBU

Thanks

[lbendlin]

see attached. What needs to be changed?

[Anonymous]

Hi @Greg_Deckler  & @lbendlin Iben

I take it that it is safe to say that this solution is no longer possible.