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.
We have a pricing table for customers with diferrent price levels. From time to time, we temporarily change the value with starting date and ending date.
In Power Bi, how do we show the price if the ending date is future, else show the price with the blank ending date. For example, for P6 price, the price should show 14. But if the Power Bi report is run later
Thanks.
Solved! Go to Solution.
Hi @Oros ,
Please use the following measure:
Measure = IF(MAX('Table'[ENDING DATE])>TODAY(), CALCULATE(MAX('Table'[PRICE]),FILTER('Table','Table'[ENDING DATE] = MAX('Table'[ENDING DATE]))), CALCULATE(MAX('Table'[PRICE]),FILTER('Table','Table'[ENDING DATE] = BLANK())))
For more details, please refer to the pbix file.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @Oros ,
Please use the following measure:
Measure = IF(MAX('Table'[ENDING DATE])>TODAY(), CALCULATE(MAX('Table'[PRICE]),FILTER('Table','Table'[ENDING DATE] = MAX('Table'[ENDING DATE]))), CALCULATE(MAX('Table'[PRICE]),FILTER('Table','Table'[ENDING DATE] = BLANK())))
For more details, please refer to the pbix file.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hello.
We have a pricing table for customers with diferrent price levels. From time to time, we temporarily change the value with starting date and ending date.
In Power Bi, how do we show the price if the ending date is future, else show the price with the blank ending date. For example, for P6 price, the price should show 14. But if the Power Bi report is run later than August 31, 2021, the P6 value should be 16 (blank ending date).
Thanks
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |