Forum Discussion
Discounted Price
How to calculate discounted price when there is different discount rates for different products?
Hi Onkarbini ,
There are must 2 tables about the product and the discounted price table.
Create a relationship between two tables by product columns
Then create a measure.
measure=max(table1[price])*max(table2[discounted])How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Onkarbini ,
There are must 2 tables about the product and the discounted price table.
Create a relationship between two tables by product columns
Then create a measure.
measure=max(table1[price])*max(table2[discounted])How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.