I want to get last column value of matrix table in power Bi card ?

[Roshan_201295]

This above type Matrix table that I have in power Bi and it is showing that month start from April and end to the March.

In that I have slicer is going to change the matrix table accordingly month they have contain.

I want to get the last column summed value here in our case is March but sometime it can anything like Dec,Jan or feb anything.

So my issue is that I want Dax function which help me to get that value so that I can use in power Bi card.

[v-yangliu-msft · Accepted solution]

Hi  @Roshan_201295 ,

Generally speaking, the order of Month in the matrix is sorted in alphabetical order. We can find the rank of Month by finding the largest rank.

Here are the steps you can follow：

1. Create measure.

rank =
RANKX(FILTER(ALL('Table'),'Table'[Category]=MAX('Table'[Category])),CALCULATE(MAX([Month])),,ASC)

Last =
CALCULATE(SUM('Table'[Amount]),FILTER(ALL('Table'),'Table'[Category]=MAX('Table'[Category])&&'Table'[rank]=MAXX(FILTER(ALL('Table'),'Table'[Category]=MAX('Table'[Category])),[rank])))

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@Roshan_201295 ,

if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

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