Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Check if row contains the same value

Hi,   Is there a way in Power BI/Dax to check if a row has matching values in two columns (Room & Building Name), and if it does and the total has already been worked out once for that room and bui...
Need Help
camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous ,

 

Is it possible to have a table without duplicated data and 1 column to identify the qtd os duplicated ?

So you can avoid it.

 

Ricardo

Anonymous's avatar
Anonymous
Not applicable
6 years ago

hi camargos88 ,

 

Unfortunately, its bookings data so the room and building will always have duplications as theres multiple bookings for that room.

 

Thanks

 

Liam

  • camargos88's avatar
    camargos88
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous 

     

    How are you calculation the total for each combination ?

    Can you explain your model ?

     

    Ricardo

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi camargos88 ,

       

      I currently have the measure of:

       

      Total Bookable Hours = CALCULATE(

          COUNT(vwDimDate[Date]),

          FILTER(vwDimDate,vwDimDate[WorkingDayFlag]=1)) * 10

       

      This however, doesn't take into consideration that a room could be duplicated for its bookable hours.

      Does that make sense?

       

      Thanks

       

      • camargos88's avatar
        camargos88
        Icon for Community Champion rankCommunity Champion
        6 years ago

        Anonymous ,

         

        I would try to rank the values using Power Query and test if it's the number 1 to assign the value..

         

        Ricardo