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

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.

Reply
NewbieFour4
New Member

calculate change in amount based on date

I get a weekly report with total goods sold up to a certain date. I want to be able to quickly calculate the difference between the goods sold between certain date (ex: increase since last week for Gen 1 is 25). Quick measures only do month over month, not week by week changes. See an example below. What calculation should I use? 

 

Datenametotal
19-MarGen 125
19-MarGen 250
26-MarGen 150
26-MarGen 2100
1 REPLY 1
amitchandak
Super User
Super User

You have to use Rank to do this week vs last week. This file has that

https://www.dropbox.com/s/d9898a48e76wmvl/sales_analytics_weekWise.pbix?dl=0

Look for 1st and 2nd Tab, Ignore WTD unless u need that

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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