I would like to ask for some help resolving a DAX formula on calculating prior period.
I have a date filter based on the daily calendar that is filtering all sales for the period 10 Oct - 20 Oct 2020.
I created a DAX formula for the previous period based on DATEADD.
However, the result for the prior period is for 10 Sep - 20 Sep 2020.
I would like to calculate the sales for the same number of days before the current period.
Any ideas and help are appreciated.