like-for-like comparison

[pani_victoria]

I have a table like:

Store	SalesforPeriod--	SalesForPreviousYear--	Sales 2 years ago--
StoreA----	100	50	80
StoreB----	200	80
StoreC----			90
StoreD----	150

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:

Store	SalesforPeriod-	SalesForPreviousYear-	Sales 2 years ago-
StoreA----	100	50	80
StoreB----	200	80

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 🙂

[Tanushree_Kapse]

Hi @pani_victoria ,

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