Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
we want to show the dynamic filter value date in powerbi desktop as below screenshot.


The filterd data will change every month so the date should update auomatically in the card value
Ex:- Azure market place Last calender month 5-1-2
Solved! Go to Solution.
Hi @saiprathapdp ,
Please create a measure like below:
Measure 2 = "Azure market place Last calender month "&CALCULATE(MIN('Table'[Date]),ALLSELECTED('Table'[Date]))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @saiprathapdp ,
Please create a measure like below:
Measure 2 = "Azure market place Last calender month "&CALCULATE(MIN('Table'[Date]),ALLSELECTED('Table'[Date]))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 83 | |
| 48 | |
| 36 | |
| 31 | |
| 29 |