Forum Discussion
Solved
DateAdd function in column not working
Hi, I was trying answer another thread and hit a problem on DateAdd function. I was trying to calculate previous month sales amount for a given sales date. I have a Date table and created 1:many...
Hi anandav,
This is a question of context, if you remove the previous month from your table view it will give you the calculation you need.
Be aware that the measure are very sensitive in terms of context and if you don't place a certain column in your measure, when you add that measure with that column the value will be off.
Regards,
MFelix
Hi anandav,
Since you are using a dates table with a relationship to the sales date in the DATEADD function you should use the dates table column and not the column from the sales table.
In my tests with your data I didn't made a date table that's why ot worked whit that column.
Regards,
MFelix
Since you are using a dates table with a relationship to the sales date in the DATEADD function you should use the dates table column and not the column from the sales table.
In my tests with your data I didn't made a date table that's why ot worked whit that column.
Regards,
MFelix
