Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I'm stuck and need help. I have a simple table with just Date and Units as shown below. I need to create a column to return value from the same month in previous year in Power Pivot Data Model. Unfortunately, I have tried the following DAX formula but all return as Blank value,
=CALCULATE(SUM([Units]), SAMEPERIODLASTYEAR(Table1[Date]))
=CALCULATE(SUM([Units]), DATEADD(Table1[Date], -1, YEAR))
Alternatively, I have tried using PREVIOUSYEAR. There are numbers showing but it's incorrect and I cant figure it out why either
=CALCULATE(SUM([Units]), PREVIOUSYEAR(Table1[Date]))
Hope someone could enlighten me, thank you!!
Solved! Go to Solution.
Hi
Sorry for the first answer, I misunderstood your question and now I noticed you want a Calculated Column, instead of a Measure.
Try this:
CALCULATE (
SUM ( Table1[Units] );
ALL ( Table1 );
SAMEPERIODLASTYEAR ( Table1[Date] )
)
Hi
Sorry for the first answer, I misunderstood your question and now I noticed you want a Calculated Column, instead of a Measure.
Try this:
CALCULATE (
SUM ( Table1[Units] );
ALL ( Table1 );
SAMEPERIODLASTYEAR ( Table1[Date] )
)
Thank you, I just realize it's a filter seting issue, not exactly the same as your solution but your help has definitely enlightened me and I appreciate a lot
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
69 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
127 | |
29 | |
27 | |
24 | |
22 |