Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

WOW Sales

I have sales by start of week. I need to calculate percentage change by WOW. Should I be using Datesbetween?

Thanks

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous 

     

    Yes, you can use Datesbetween in your scenario.

    For example,

    DATESBETWEEN(<dates>, DATE(Date_Table[Start of the week]), TODAY())

     

    If you have contiguous dates, you may also use: DATEADD(DateTime[DateKey],-1,day) 

     

    If you find my answer helpful, please leave a like and Accept it as a solution.

     

    Cheers!

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    Please provide sample data and expected results, remember to hide private data.

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.