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.
Hello Eveyone,
I have sales, sales date column i want to create measure which shows last date from sales date column
sales date column in used in filter pane and Measure has to show Last date from sales date column based on filter selection
Sales Date |
11-11-2022 |
12-11-2022 |
13-11-2022 |
14-11-2022 |
15-11-2022 |
From above column
By default Last date is 15th Nov 2022, if filter slection is 14th Nov 2022 then last date must show 14th Nov 2022
Solved! Go to Solution.
Hi @Abhilash_P
A simple measure with MAX is able to meet your requirement.
Latest Sales Date = MAX('TableName'[Sales Date])
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @Abhilash_P
A simple measure with MAX is able to meet your requirement.
Latest Sales Date = MAX('TableName'[Sales Date])
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
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 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |