Quarter over quarter

[Anonymous]

Hi all, I believe this is something not very serious but I'm  strugling and  need bit of your help with DAX to compare quarter over quarther:

 So I am comparing row value with the value 3 months back. 

Currently I've tried: 

Desired result =

CALCULATE(SUM('Portfolio status'[Progress, %]),

PREVIOUSQUARTER('Portfolio status'[Period]))

I also tried PARALELPERIOD and DATEADD - none of them worked 😞

[Anonymous]

Funkcje, ktore operuja na datach, potrzebuja odpowiedniej tabeli. Nie mozesz sobie byle jakiej kolumny wcisnac jako argumentu. Zapoznaj sie z dokumentacja jednej z funkcji typu time-intelligence: https://dax.guide/previousquarter. Dobrze przeczytaj od poczatku do konca.

Functions that operate on dates require a proper date table. You can't just stick any column from any table as the argument into them. Please make yourself familiar with at least one of the time-intelligence functions at https://dax.guide/previousquarter and read through the docs from beginning to end.

[Jihwan_Kim]

Hi, @Anonymous 

I am not sure how your data model looks like, but I think it is better to use Dim-Calendar-Table when creating time intelligence measures.

Please check the below picture and the sample pbix file's link down below.

All measures are in the sample pbix file.

Progress Previous Quarter =

CALCULATE( [Progress], DATEADD('Calendar'[Date], -1, QUARTER))

https://www.dropbox.com/s/7t8bjnqm2i8sf7s/aleksandra.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/