i´m having an issue with the following excercise.
I want a calculated column with a true/false statement in which works like this:
if previous month status is anything that doesn´t contains the word "OK" in it AND "actual month contains the word "ok"="TRUE", other than this, "FALSE".
I desire the same results shown in the table above.
This is the link for the data:
Thanks for the help in advance!
Go to Solution.
If the Month column is an actual date I was able to get it to work with this.
VAR ClientID = 'YourTable'[Client ID]
VAR PMStatus =
MAX ( 'YourTable'[Status] ),
ALL ( 'YourTable' ),
'YourTable'[Client ID] = ClientID,
DATEADD ( 'YourTable'[Month], -1, MONTH )
VAR CMStatus = 'YourTable'[Status]
NOT ISBLANK ( PMStatus )
&& NOT CONTAINSSTRING ( PMStatus, "OK" )
&& CONTAINSSTRING ( CMStatus, "OK" )
View solution in original post
i don´t actually know what you really did right there but, it actually worked! I appreciate it!
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!