Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
This is quite amazing Thanks !
Hi again Roshan
Create Calandar table with:-
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.
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
Hi Roshan
Click here to download a example solution
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |