Forum Discussion
YOY % Change
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 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 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?
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.