Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DateADD function does not work for Q1, maybe due to a filter?

Hi!   As I was doing an exercise I faced a problem. The exercise was to add another measure which shows for each time period in 2015 what the sales were in the previous quarter, using the CALCULATE...
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous ,

It seems that you have problem when create measure with Calculate () and DATEADD().

Please refer to my test pbix.

In my example, I have the sales data from 2018-2019 and a calendar table.

I have created the relationship between the two tables like below.

Then create the measure like this.

previous quar =
CALCULATE ( SUM ( 'Sheet5'[Value] ), DATEADD ( 'calendar'[Date], -1, QUARTER ) )

Here is my test output.

If you still need help, please share your data sample and your desired output so that we could help further on it.

Best  Regards,

Cherry

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    v-piga-msft 

     

    Thank you for your reply. Unfortunately this is not the solution that works for me as I already created the relationship between the two tables. 

     

    Is it possible for me to share the PBI file here? This way you  can take a look yourself