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
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
139 | |
112 | |
109 | |
71 | |
58 |
User | Count |
---|---|
263 | |
131 | |
123 | |
100 | |
96 |