Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi - I am looking to do the following in either a Card or a Text Box:
* I would like to display the earliest date and the latest date of a specific field
* I would like values NOT to change upon filtering
Example:
"Data date range from 01/01/2022 to 01/31/2022"
Where the earliest date is 01/01/2022 and the latest date is 01/31/2022 from the specific field in the table (Table: ABC; Field: SalesDate).
Note: I am using the verision of Power BI on the cloud (SAAS).
Any assistance would be appreciated. Jerry
Hi Greg -
Thank you for the assistance.
I am a little confused to where to add the code.
I am using the Power BI applicatiokn on a cloud network.
I added the code to a text box and a card - it did not work.
I must be doing something incorrect.
Your assistance is greatly appreciated.
Standing by - jerryr125
@jerryr125 Try:
Earliest Measure = MINX(ALL('Table'), [Date])
Lastest Measture = MAXX(ALL('Table'), [Date])
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
8 | |
7 | |
2 | |
2 | |
2 |
User | Count |
---|---|
6 | |
5 | |
4 | |
4 | |
4 |