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 a...
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/

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/