Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi all,
I have data as follows:
Date MonthnYear
1/7/2020 July 2020
2/7/2020 July 2020
3/7/2020 July 2020
4/7/2020 July 2020
5/7/2020 July 2020
6/7/2020 July 2020
1/8/2020 Aug 2020
2/8/2020 Aug 2020
3/8/2020 Aug 2020
4/8/2020 Aug 2020
6/8/2020 Aug 2020
8/8/2020 Aug 2020
8/8/2020 Aug 2020
I have my max date values measures as follows:
Solved! Go to Solution.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
@Anonymous
Your dax is almost ready .Use below change
Formatted Max Date=
VAR MaxDate = MAX('Date Table (Actuals)'[Date])
VAR MaxDateAll = CALCULATE([MaxDate], ALL('Date Table (Actuals)'))
RETURN
FORMAT(MaxDateAll,"MMM YYYY")
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Hi @Anonymous
Try
FORMAT(MAX('Date Table (Actuals)'[Date]),"mmmm YYYY")
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
This works but I need All as well, to ignore row level filter in my visuals
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
55 | |
35 | |
34 |
User | Count |
---|---|
99 | |
56 | |
53 | |
44 | |
40 |