Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculated Column to Check Repeat Failed User

Hi,

I want to create a calculated column to check users that failed for a second or more time in a month.

The first time they failed wont count as repeat but any other month after that will count as repeat.

 


i am new to this please help.

Need Help
Show and Tell
  • SamInogic's avatar
    SamInogic
    3 years ago

    Hi Anonymous ,

    We have considered below table as mentioned in your requirement,

    You can use below DAX expression to create new calculated column in your table,

    StatusResult = IF(CALCULATE( COUNT(UserTbl[Result]), FILTER( UserTbl, UserTbl[Month]= EARLIER(UserTbl[Month]) && UserTbl[Result] ="Failed" )) > 1, "Repeat", "Non Repeat" )

    Please refer to the below screenshot for the result.


    Thanks!

    Inogic Professional Services Division

    Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

    Drop an email at [email protected]

    Services:  http://www.inogic.com/services/

    Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

1 Reply

  • SamInogic's avatar
    SamInogic
    Super User
    3 years ago

    Hi Anonymous ,

    We have considered below table as mentioned in your requirement,

    You can use below DAX expression to create new calculated column in your table,

    StatusResult = IF(CALCULATE( COUNT(UserTbl[Result]), FILTER( UserTbl, UserTbl[Month]= EARLIER(UserTbl[Month]) && UserTbl[Result] ="Failed" )) > 1, "Repeat", "Non Repeat" )

    Please refer to the below screenshot for the result.


    Thanks!

    Inogic Professional Services Division

    Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

    Drop an email at [email protected]

    Services:  http://www.inogic.com/services/

    Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/