How to get matrix last column value inside the card of power Bi ?

[Roshan_201295]

Hi

I am working on Finance data and That Data I have shown on the power bi dashboard in matrix table.
At the columns side I have month from March to April as per indian standard financial year.
I want to show the latest month data inside card of power Bi.

For example 

Lets suppose I have data from March to december and in that case I want data of decemeber only inside card and if dashboard
will get automate that time thing should capture that moment dynamically for any selection of finacial year in slicer.

I have tried but Dax for that one but not gettting as per my requirement I want intermediate month data also if in case I do have insufficient data till any month in any financial year of indian standard.

Please suggest Any Dax formulae so that I can get latest value of any month inside card of powerBi.

[v-yalanwu-msft · Accepted solution]

Hi, @Roshan_201295 ;

You could create a flag measure, then apply it into visual filter.

flag = IF(EOMONTH(MAX('Table'[Date]),0) =EOMONTH(MAX('Slicer'[Date]),0),1,0)

Then apply it into filter.

The final output is shown below:

Or can you share a simple example and what you want to output? It makes it easier to give you a solution.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Roshan_201295]

This is quite amazing Thanks !

[speedramps]

Hi again Roshan

Create Calandar table with:-

•  Start of month  -  01/01/2021, 01/02/2021, 01/03/201, etc
• Month Name - Jan 2021, Feb 2021, Mar 2021, etc 
• Fiscal Year - 2020/22, 2021/22 , 2022/23, etc

In the moddlet tab sort Month Name by Start of month

Then add a tart of month columns to your fact table

The create 1:many relationship from calendat to fact table by Start of month

Congratulations, you can now create visuals with totals sales by Fiscal Year, by month.

I am an unpaid Power BI volunter. Please click the thumbs up if you like me helping you. Also click solved if I fix your problem. One problem per ticket please. If you have a new or related problem then start a new ticket.

[Roshan_201295]

Hi I want Month start from April and end with March ..I want dax in Month Not on datewise @speedramps 

Please provide order from April and end with march

[speedramps]

Hi Roshan

Click here to download a example solution 

Lastest value =

VAR Last_date = MAX(Facts[Start of month])

RETURN

CALCULATE(

SUM(Facts[Sales]),

Facts[Start of month] = Last_date

)

I am a unpaid Power BI volunteer. Please click the thumbs up if you like me trying to help. Then click solved if this fixes your problem. Thank you.

Warm regards, speedramps