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

3 Replies

  • 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)

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    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!

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    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!