YOY % Change

[kalkhudary]

Hi everyone, 

I am looking into getting the YOY % change for the Price Index values. I do have the date set in a quarterly basis, so I am thinking the only way here to get it is through creating a measure. I am not sure how to write a dax that would reflect % change for each type (New Housing and residential type) - Condo Only, House only, Land only from year to year.

I have attached a sample of the dataset. Hope any one could help. 

[AbbasG · Accepted solution]

@kalkhudary Hi, you can do it through the quick measure option (Time intelligence ==> Year over year change)

Before that, you can split your table by category. i.e. House, Condo, and Land.

Below image for your reference. Quick measure time intelligence function.

Split the tables by category.

Output, hope it helps 🙂

[kalkhudary]

@AbbasG Thank you so much. I tried it and it works. Thinking if I applied the same quick measure to the combine type dataset. Wouldn't it work as well. Should it be that the aggregation picks dates and calculate or is there filters that need to be applied in this case. As I do not wish to split the 3 types in 3 tables. What do you think?

[Anonymous]

Hi there

Did you get how to make it work for the combined dataset if you do not wish to have separate tables? I have the same question as yours. Thank you

[kalkhudary]

If the data is in a single table, When you click on the datapoint you are now setting the filter context so that the min and max range is the same as the clicked value and it won't give you the intended result. That means you need to provide your desired min value from a different, disconnected table, which I am thinking how to do it. Will we need to create the same table query and then it works, still exploring.

[AbbasG · Accepted solution]

@kalkhudary Hi, it should work for the combined data as well. If it helped you achieve the desired output. Kindly mark it as an accepted solution.

You will need to apply visual-level filters when you want to see data only for one category.

[AbbasG · Accepted solution]

@kalkhudary Hi, you can do it through the quick measure option (Time intelligence ==> Year over year change)

Before that, you can split your table by category. i.e. House, Condo, and Land.

Below image for your reference. Quick measure time intelligence function.

Split the tables by category.

Output, hope it helps 🙂