Revenue calculation based on Date column

[NidhiBhusari]

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.

[v-xulin-mstf]

Hi @NidhiBhusari

Is your issue solved?

If the issue has been solved, please adopt the solution to help others

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[v-xulin-mstf]

Hi @NidhiBhusari

Could you provide your sample data and expected output?

What are the decisions in the context? Is it determined by the current row or is there a slicer?

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[Anonymous]

Hi @NidhiBhusari , you can use the following approach

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