Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
User | Count |
---|---|
85 | |
75 | |
73 | |
70 | |
57 |
User | Count |
---|---|
98 | |
97 | |
92 | |
78 | |
70 |