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.
Hi,
good day.
I have a table called POs, and there are two columns; one for PR price and another for PO price and I want to get the following:
1-( PR -PO )/PR
2- The Average of that.
3- how many row was "the result in 1" greater than 20%
can you help.
Best Regards.
Solved! Go to Solution.
Hi, @freevission2019
Please correct me if I wrongly understood your question.
If you are looking for something like below,
please check the below link, which is the sample pbix file.
Otherwise, if it is OK with you, please share your sample data file, then I can look into it to come up with more accurate measures.
Jihwan Kim
If this post helps, then please consider accept it as the solution to help the other members find it more quickly.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank you very much Jihwan.
perfect😊 👌
Hi, @freevission2019
Please correct me if I wrongly understood your question.
If you are looking for something like below,
please check the below link, which is the sample pbix file.
Otherwise, if it is OK with you, please share your sample data file, then I can look into it to come up with more accurate measures.
Jihwan Kim
If this post helps, then please consider accept it as the solution to help the other members find it more quickly.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 |
---|---|
108 | |
105 | |
87 | |
74 | |
66 |
User | Count |
---|---|
124 | |
112 | |
96 | |
80 | |
72 |