The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 and DATEADD function.
So the new measure I made was:
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
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