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,
I have been asked to compare if a specific id is present across a number of years - yes and no means they are present, blank means they are not present.
Below is an example of what i need - the data is within one table
Essentially i need the result in column e, stating whether the ID is present within each year column "yes", "no", and ignoring blanks.
Any help or additional questions needed please let me know
Kind regards,
Callum
Result | |||||
A | b | c | d | e | |
ID | 2019 | 2020 | 2021 | in 2021 and 2020 and 2019? | |
000113 | No | Yes | Yes | ||
000114 | Yes | No | |||
000115 | Yes | No | |||
000116 | No | Yes | Yes | ||
000117 | Yes | No |
Hi @SuperCal99 ,
You can create a calculated column using the IF condition as mentioned below:
e = IF(AND(AND(b=" ",c="No"),d="Yes"),"Yes",
IF(AND(AND(b=" ",c=" "),d="Yes"),"No",
IF(AND(AND(b=" ",c=" "),d="Yes"),"No",
IF(AND(AND(b="No ",c=" "),d="Yes"),"Yes",
IF(AND(AND(b=" ",c="Yes"),d="No"),"No",blank())))))
I hope this helps!
Did I answer your question? Mark my post as a solution!
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |