Forum Discussion
DATEADD function
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))
=> normally here it will show the sales of last year , but when i put my results in a table it shows the sales of the next year which is the opposite (when i change -1 with 1 it shows the correct results )
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
4 Replies
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 , it should work. Just make a sure the year is from dim_Date, also it is marked as date table