Forum Discussion

jawilson808's avatar
jawilson808
Icon for Helper I rankHelper I
4 years ago

Last Week Sales with Date Hierachy

Hi all!

 

I am looking for some assistance with the Dateadd Dax. I have two data points I am trying to show by date, current week sales and last week's sales. Creating a dax for last week's sales is not an issue by using calculate(sales,dateadd(date,-7,day)). When doing so I get the correct value, however, when adding it to a matrix that has a date hierarchy, last week's sales only provide a total, whereas I would like to see each daily amount. If I do not use the date hierachy and use date instead, the day by day total shows for last week with the correct amounts. Below is what is returned.

 

Undesired display using a date hierarchy. However, last week total is correct.

Without date hierarchy. Day-by-day total shows as desired. 

How can I achieve the same result by using the date hierarchy?

 

 

 

Need Help
Tips and Tricks

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi jawilson808 , 

    I cannot reproduce your issue.

    It may some errors on your DAX. If you are using selectedvalue, please modify the formula.

     

    Could you please provide your pbix file without privacy information and the dax formula?

     

    Best Regards

    Community Support Team _ Polly

     

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