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.
Hello Community,
I came up with below 4 formulas for the WoW calculation but I'm not able to calculate the value for the previous week!
I have context filters applied! The DAX 4 returns (blank) value but the DAX 3 (current week value) returns the correct value
Dax 1 (Current Week Rank) :
Solved! Go to Solution.
Hi @amane ,
You have to add "ALL" after filter function,since they are measures.
See below:
W Test 1 = CALCULATE(MAX(Sheet1[Week Rank]) , FILTER(ALL(Sheet1) , Sheet1[Start_Date] < Sheet1[current_date]))
W Test 2 = CALCULATE(MAX(Sheet1[Week Rank]) , FILTER(ALL(Sheet1 ), Sheet1[Start_Date] < Sheet1[current_date])) - 1
W Test 3 =
VAR WW = [W Test 1]
RETURN
CALCULATE(
SUM(Sheet1[Value]),
FILTER(ALL(Sheet1) , Sheet1[Week Rank] = WW
)
)
W Test 4 =
VAR WW = [W Test 2]
RETURN
CALCULATE(
SUM(Sheet1[Value]),
FILTER(Sheet1 , Sheet1[Week Rank] = WW
)
)
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Here is the attached file : https://drive.google.com/file/d/1MmgEq7wchWK-Gj9dne4pf3hhJRBmceyW/view?usp=sharing
Hi @amane ,
You have to add "ALL" after filter function,since they are measures.
See below:
W Test 1 = CALCULATE(MAX(Sheet1[Week Rank]) , FILTER(ALL(Sheet1) , Sheet1[Start_Date] < Sheet1[current_date]))
W Test 2 = CALCULATE(MAX(Sheet1[Week Rank]) , FILTER(ALL(Sheet1 ), Sheet1[Start_Date] < Sheet1[current_date])) - 1
W Test 3 =
VAR WW = [W Test 1]
RETURN
CALCULATE(
SUM(Sheet1[Value]),
FILTER(ALL(Sheet1) , Sheet1[Week Rank] = WW
)
)
W Test 4 =
VAR WW = [W Test 2]
RETURN
CALCULATE(
SUM(Sheet1[Value]),
FILTER(Sheet1 , Sheet1[Week Rank] = WW
)
)
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |