Forum Discussion

Georgia_H's avatar
Georgia_H
Icon for Helper I rankHelper I
2 years ago

Need urgent help

Hello, I have this use case and i need some input. I need a logic to check on the same Billing Group Name that appeared twice for the same date: 3/14/2024. For this case, plc-gcp appeared twice but...
Need Help
Show and Tell
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

pls try this

Georgia_H's avatar
Georgia_H
Icon for Helper I rankHelper I
2 years ago

Thank you Ahmedx for the suggested solution, however i still encounter error below: What could be the reason for this?

 

 

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    2 years ago

    in the SUMMARIZE function I have only 2 columns from one table, but it looks like you have 3 and one of them is from another table

    SUMMARIZE(ALLSELECTED('Table'),
  'Table'[Billing Group Name], // it is column 1
'Table'[Type] // it is column 2
),
    • Georgia_H's avatar
      Georgia_H
      Icon for Helper I rankHelper I
      2 years ago

      Hi Ahmedx 

      Thanks for your swift response. I am using 2 columns as well from the same table. This is the real table name and column names. I just apply the same logic with the real data. That's all.

       

      • Ahmedx's avatar
        Ahmedx
        Icon for Super User rankSuper User
        2 years ago

        maybe it’s because of the long column name, I can’t say for sure