The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello Power BI gurus,
I'm trying to create the following Measure based on the logic below. Data source is located in Report Sharepoint.
Sum of items sold in Week 26 - Sum of items sold in Week 25 = 4 or (4+3) - (2+1) = 4
Week Number | Item Sold |
24'W26 | 4 |
24'W26 | 3 |
24'W25 | 2 |
24'W25 | 1 |
24'W24 | 4 |
24'W24 | 5 |
24'W23 | 8 |
24'W23 | 7 |
24'W23 | 6 |
24'W22 | 5 |
I've tired with the following formula however still unbale to get it to work. Would appreciate any guidance given.
WoW Item sold = SUM('Report SharePoint'[Week Number IN {"24'W26"}) - SUM('Report SharePoint'[Week Number IN {"24'W25"})
Solved! Go to Solution.
@reubanrao93 , You can create a measure using variables
ItemsSoldDifference =
VAR Week26Sales = CALCULATE(SUM('Table'[Item Sold]), 'Table'[Week Number] = "24'W26")
VAR Week25Sales = CALCULATE(SUM('Table'[Item Sold]), 'Table'[Week Number] = "24'W25")
RETURN
Week26Sales - Week25Sales
Proud to be a Super User! | |
@reubanrao93 , You can create a measure using variables
ItemsSoldDifference =
VAR Week26Sales = CALCULATE(SUM('Table'[Item Sold]), 'Table'[Week Number] = "24'W26")
VAR Week25Sales = CALCULATE(SUM('Table'[Item Sold]), 'Table'[Week Number] = "24'W25")
RETURN
Week26Sales - Week25Sales
Proud to be a Super User! | |
Hi @reubanrao93 -create a measure that calculates for week-over-week difference as below.
WoW Item Sold =
CALCULATE(
SUM('Report SharePoint'[Item Sold]),
'Report SharePoint'[Week Number] = "24'W26"
) -
CALCULATE(
SUM('Report SharePoint'[Item Sold]),
'Report SharePoint'[Week Number] = "24'W25"
)
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
User | Count |
---|---|
144 | |
121 | |
110 | |
54 | |
46 |
User | Count |
---|---|
219 | |
107 | |
96 | |
94 | |
93 |