Forum Discussion

pani_victoria's avatar
pani_victoria
Icon for Helper III rankHelper III
3 years ago

like-for-like comparison

I have a table like:

 

StoreSalesforPeriod--SalesForPreviousYear--Sales 2 years ago--
StoreA----1005080
StoreB----20080 
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:

StoreSalesforPeriod-SalesForPreviousYear-Sales 2 years ago-
StoreA----1005080
StoreB----20080 

 

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 🙂

1 Reply

  • Tanushree_Kapse's avatar
    Tanushree_Kapse
    Icon for Impactful Individual rankImpactful Individual
    3 years ago

    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