Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hello,
I've been having difficulty trying to figure a way to get the outputs from 3 columns if they contain a certain string, I'm bringing these items from other tables since there's no way to create relationships and merging has been giving odd results.
So, if any of the types contain "Yes" they should be Accepted, if else Decline
ID | TYPE1 | TYPE2 | TYPE3 | EXPECTED OUTPUT COLUMN | |
1 | YES | YES | NO | Accept | |
2 | YES | YES | YES | Accept | |
3 | NO | NO | YES | Accept | |
4 | NO | NO | Decline |
TIA
Solved! Go to Solution.
Excel worksheet formula is way too powerful for such a simple question,
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Excel worksheet formula is way too powerful for such a simple question,
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
I would assume it would be that route, but for some reason it wasn't calculating correctly just with IF but this worked.
Hi:
This is a little wild but you can try as a measure:
Create a conditional column and fill out the boxes to match what you need (see screenshot below)
User | Count |
---|---|
13 | |
8 | |
8 | |
7 | |
5 |
User | Count |
---|---|
23 | |
15 | |
15 | |
10 | |
7 |