Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Experts!
I am trying to figure out how to do something but cant quite grasp it, can someone help me?
I want to track the "Improvement status" every day for the each product as explained in the "Desired results". To arrive "Improvement status" , I have calculated "Selling Price/Cost", "Day's Selling/Cost", "Gain". Also took the help of "Calculated table" for "Total cost" , "Total selling price" and "Day's Selling/Cost" of all the products per day as shown in the images. Please use url for raw data(data adds every day) and calculations ( https://docs.google.com/spreadsheets/d/1IfOjW_175gu1wC82Nb7CSGsSdtiXQm3tr4NcEhqrays/edit?usp=sharing...
Data:
Desired Result (Improvement Status) :
Thank you in advance!!
Solved! Go to Solution.
Thank you very much. It worked for me. 🙂
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |