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 everybody !
I want to create an if function between two tables.
In fact, if I have nothing in a specific column in my second table, my personalize column (my function) take the number 3.
I try with contain but unsuccessful.
Here is my example : Table 1
Table 2
My two tables have same rows.
Thanks
Best regards
David
Hi @DavidB023
You can simply use = or <> with LEFT() or RIGHT()
For example your date is 01/01/2018 and you want to verify if it contains 2018 type :
Column = IF(RIGHT(Table[DateColumn];4)="2018";0;3)
Hope this help
- Quentin
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |