Forum Discussion

Slukuleni's avatar
Slukuleni
Frequent Visitor
1 year ago
Solved

Find duplicates

I get tge beklow error on this formula in DAX   The syntax for ')' is incorrect. (DAX(VAR Duplicates = 'Dim GL Account FPA'[Dim GL Account FPA.FPA Account Code])).   Count Duplicates = VAR Dupli...
  • v-hashadapu's avatar
    v-hashadapu
    1 year ago

    Hi Slukuleni , Thank you for reaching out to the Microsoft Community Forum.

     

    Please refer attached .pbix file and see if it solves your issue. If not, please provide details along with sample data.

     

    If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
    Thank you.

v-hashadapu's avatar
v-hashadapu
Icon for Community Support rankCommunity Support
1 year ago

Hi Slukuleni , Thank you for reaching out to the Microsoft Community Forum.

 

Please refer attached .pbix file and see if it solves your issue. If not, please provide details along with sample data.

 

If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.

  • v-dineshya's avatar
    v-dineshya
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi @Slukuleni ,

    Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
    Thank you.