Hi, Please help me to convert the following Tableau calculation in DAX.
IF { FIXED [Student Id]:SUM(IF CONTAINS([XYZ],'FGEN') THEN 1 ELSE 0 END)} > 0 THEN 'First Gen' ELSE 'Non-First Gen' END
Thank you!
Hi @Anonymous
Can you please provide some dummy data to explain the expected result you want to have? I don't have experience in Tableau so some sample data and expected output would help me understand it better. And do you want to add a new column in an existing table?
Best Regards,
Community Support Team _ Jing
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
125 | |
78 | |
69 | |
55 | |
55 |
User | Count |
---|---|
200 | |
104 | |
85 | |
80 | |
77 |