Forum Discussion
Oros
Post Prodigy
Post ProdigyPricing Table
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 ...
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
v-deddai1-msft
Community Support
Community SupportHi 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
