Forum Discussion

RookieUser's avatar
RookieUser
Regular Visitor
4 years ago

Compare two text values in a same column

Dear Community, 

I am currently facing an issue to display what I really need in Power BI Desktop. 

I have a dataset which looks like this : 

IDDateModelBrand
101/08/2021AirMaxNIKE
101/08/2021AirForceNIKE
201/08/2021NMDADIDAS
201/08/2021BOOSTADIDAS
101/09/2021AirMaxNIKE
101/09/2021AirForceNIKE
201/09/2021SUEDEPUMA
201/09/2021NMDADIDAS


I have two slicers in my Power BI report : Date1 & Date2. They contain same values as "Date" column but there are not relationship between them in the data model. 
My goal is to compare the difference between these two selected dates and to detect changes. 

The result should be : 

IDDateModelBrand
201/08/2021BOOSTADIDAS
201/09/2021SUEDEPUMA


Can you help me with this ? 

Thank you for your time. 


1 Reply

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    Hi RookieUser 

     

    Something is not clear here, or I can't get it 🙂

    Have you used the Date column in those two slicers? If yes, after you selecting two different dates on those slicers, the table will show nothing.

     

    Would you mind adding more details to your post? Do you want to calculate the days between those two dates?

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos ✌️!!