Forum Discussion

tez's avatar
tez
Resolver I
6 years ago

Date parameter for DAX table comparison

Hi! I have to create a table comparison within Power BI. Here´s demo data for better understanding. I have one table which consists of a number of IDs for some timestamps: I have to create a ...
stevedep's avatar
stevedep
Memorable Member
6 years ago

Hi,

 

Perhaps the following is what you are looking for. This will check per code if the number of dates is equal to the number of selected dates, if so they appear in both (or more).

 

 

 

PresentInBoth = 
var NumberOfDates = CALCULATE(DISTINCTCOUNT(Table1[Date]);all(Table1);ALLSELECTED(Table1[Date]))
return 
CALCULATE(DISTINCTCOUNT(Table1[Date])) = NumberOfDates

 

 

 

Kind regards,

 

Steve. 

 

Please accept as solution if this is what you are looking for.

  • tez's avatar
    tez
    Resolver I
    6 years ago

    Hi stevedep,

    thank you for this hint, but I could not manage to get a solution. It seems to me, that it is not possible to use this context, because either it filters the target table in a way not intended, or it does not work at all.

    Regards,

    Thomas.