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.
Hi,
I'm trying to make this measurement automatically update every week
Delta Sold = (Sales[Total Sold](Sales[Week]=27))-(Sales[Total Sold](Sales[Week]=26))
how should I replace that number? so the Delta always showing update compared to last week when I put this measurement in a card
the thing is week column's format is just number
Total Sold | Week |
109 | 20 |
100 | 21 |
102 | 22 |
120 | 23 |
115 | 24 |
110 | 25 |
120 | 26 |
125 | 27 |
Solved! Go to Solution.
Try something like this.
Measure =
VAR LastVisibleWeek = MAX ( Sales[Week] )
VAR PreviousWeek = LastVisibleWeek - 1
VAR AmountForCurrentWeek =
CALCULATE ( SUM ( Sales[Total Sold] ), Sales[Week] = LastVisibleWeek )
VAR AmountForPreviousWeek =
CALCULATE ( SUM ( Sales[Total Sold] ), Sales[Week] = PreviousWeek )
VAR Result = AmountForCurrentWeek - AmountForPreviousWeek
RETURN
Result
Hi @Kemalnugraha ,
You will need a Calendar Table with week.
Have a look at this blog. (pbix file is attached too).
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Try something like this.
Measure =
VAR LastVisibleWeek = MAX ( Sales[Week] )
VAR PreviousWeek = LastVisibleWeek - 1
VAR AmountForCurrentWeek =
CALCULATE ( SUM ( Sales[Total Sold] ), Sales[Week] = LastVisibleWeek )
VAR AmountForPreviousWeek =
CALCULATE ( SUM ( Sales[Total Sold] ), Sales[Week] = PreviousWeek )
VAR Result = AmountForCurrentWeek - AmountForPreviousWeek
RETURN
Result
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |