Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Greeting lovely members.
i used the function Dateadd and it seems like it's glitching (im not sure tho)
Last year sales = CALCULATE(Fact_Sales[Sales Value],DATEADD(Dim_Date[Date],-1,YEAR))
Solved! Go to Solution.
@Anonymous , If this is a measure
Like
Last year sales = CALCULATE(Sum(Fact_Sales[Sales Value]),DATEADD(Dim_Date[Date],-1,YEAR))
or Sales Value is a measure. then your formula
if you need a new column , please share data
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Why Time Intelligence Fails - Power bi 5 Savior Steps for TI: https://youtu.be/OBf0rjpp5Hw
@Anonymous , If this is a measure
Like
Last year sales = CALCULATE(Sum(Fact_Sales[Sales Value]),DATEADD(Dim_Date[Date],-1,YEAR))
or Sales Value is a measure. then your formula
if you need a new column , please share data
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Why Time Intelligence Fails - Power bi 5 Savior Steps for TI: https://youtu.be/OBf0rjpp5Hw
First Thanks for your answer .
that's my output . as you see LY Sales measure show sales of last year so all good .
my question here why it doesnt work when i put -1 in the interval and works when i put 1 ?
@Anonymous , it should work. Just make a sure the year is from dim_Date, also it is marked as date table
Yes it is .
i used an M function to build my DimTable . and the type of the column Dim_date[Date] is a Date.
The function DateAdd accept only Date column anyway.
User | Count |
---|---|
94 | |
86 | |
78 | |
72 | |
66 |
User | Count |
---|---|
115 | |
106 | |
85 | |
65 | |
64 |