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.
Solved! Go to Solution.
Hi,
You could try something like this.
LastSalesDate = CALCULATE( MAX( 'product Sales'[sold_date] ), FILTER( 'product Sales', 'product Sales[product number] = 'products table'[product number] ) )
Hi,
You could try something like this.
LastSalesDate = CALCULATE( MAX( 'product Sales'[sold_date] ), FILTER( 'product Sales', 'product Sales[product number] = 'products table'[product number] ) )
Thanks for replying this worked, but an even easier solution in the end was a simple MAX (as you suggested) as a measure and then the end user tool would give the correct answer when teh measure was formatted as a date.
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 |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |