Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Experts
See attached sample PBIX
I want to divide the sales for each row by the Total for that Year and By the Channel. So in the FACTSales Add up the total Sales by Year and by Channel then Divide each row by that Sum. Then Find the Multiple in the Lookuptable and multiple each row by the that mulitpler..
Example.
Year 2020
Total ALT Sale =19579
Total DIR Sale = 22259
For each row that has Channel DIR / 2259 and for each row that has ALT / 19579
Then lookup in LOOKUPTable Column Sales U$D find the mulitpler for ALT and Dir in our case ALT= 1.8 and DIR = 18.1 then mutiple each row by that number if its a dir or alt in the sales table
Sample File..
https://www.dropbox.com/s/dclkz5shn3a40gv/test_.pbix?dl=0
Solved! Go to Solution.
Hi, @Anonymous
please check the below picture and the link down below, whether it is what you are looking for.
https://www.dropbox.com/s/lg43t2e49vabvsw/test_.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
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.
Hi, @Anonymous
please check the below picture and the link down below, whether it is what you are looking for.
https://www.dropbox.com/s/lg43t2e49vabvsw/test_.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
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.
Hi Kim - Can you help with...
Thanks you sir looks good let me test and come back to you
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |