Calculated Column to Check Repeat Failed User

[Anonymous]

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.

[SamInogic · Accepted solution]

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 crm@inogic.com

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

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