like-for-like comparison

pani_victoria — Fri, 27 Jan 2023 06:50:56 GMT

I have a table like:

I would like to compare only those stores where there are sales only in the selected period and the period of the previous year.

The result I want to get:

I tried to use the methods that are described in this article, but I can't figure out how to set my own condition
https://www.daxpatterns.com/like-for-like-comparison/

Please, help me 🙂

Re: like-for-like comparison

Tanushree_Kapse — Fri, 27 Jan 2023 07:03:55 GMT

You can simply apply these visaul level filters of not blank on respective fields.

Hope this helps.

Mark this as a solution, if it helps. Kudos are always appreciated.

Thanks,

Tanushree