Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sriramk
Helper I
Helper I

Finding daily improvement for each product

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:

sriramk_0-1669469011994.png

 

Desired Result (Improvement Status) :

sriramk_2-1669469494070.png

 

Thank you in advance!!

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

2 REPLIES 2
sriramk
Helper I
Helper I

Thank you very much. It worked for me. 🙂

lbendlin
Super User
Super User

See attached

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors