Forum Discussion

NidhiBhusari's avatar
NidhiBhusari
Helper IV
5 years ago

Revenue calculation based on Date column

Hi, I need a help in writing a Dax where I want to calculate Revenue based on Date column and revenue value should be for Last three months and next three months.
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi NidhiBhusari , you can use the following approach

Conditional_revenue = CALCULATE(SUM(Revenue),DATEADD([Date Column],-3,Month,DATEADD([Date Column],3,Month)