Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
I need your help with creating an IF-formula in Power BI which shows me the following situation:
IF two names are beneath each other AND in the next column for the same rows , there is atleast ONE Yes, then show me "Check is done" .. IF that's not true show me "Check is not done" .
To illustrate this so that i'm clear, see the below print screen, I want to have the text in the third column
All my columns have the text format.
Many Thanks!!,
DSabsi
Solved! Go to Solution.
Hi @dsabsi
Try the following
1. Add an index column from 1 using the query editor.
2. Create a column in your table as
Status = IF (Calculate(DistinctCOUNT((DoneorNot[CheckDone]))+0, Filter(DoneorNot,DoneorNot[CheckDone]= "Yes" && EARLIER(DoneorNot[Name]) = DoneorNot[Name])) >0,"Check is done", "Check is not Done" )
3. Now plot the table using Index, Name, CheckDone, Status
Sample screen shot
If this works for you please accept this as a solution adn also give KUDOS.
Cheers
CheeenuSing
Hi @dsabsi
Try the following
1. Add an index column from 1 using the query editor.
2. Create a column in your table as
Status = IF (Calculate(DistinctCOUNT((DoneorNot[CheckDone]))+0, Filter(DoneorNot,DoneorNot[CheckDone]= "Yes" && EARLIER(DoneorNot[Name]) = DoneorNot[Name])) >0,"Check is done", "Check is not Done" )
3. Now plot the table using Index, Name, CheckDone, Status
Sample screen shot
If this works for you please accept this as a solution adn also give KUDOS.
Cheers
CheeenuSing
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |