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.
Hello i need to calculated column to flag rows that are having the same date as ones from other tables, like this:
Also, i have no relationship between these two tables:
ID | Date | Check Column |
1 | 05/02/2020 | 1 |
1 | 06/02/2020 | 0 |
2 | 05/02/2020 | 1 |
2 | 07/02/2020 | 0 |
3 | 05/02/2020 | 0 |
4 | 05/02/2020 | 0 |
5 | 06/02/2020 | 0 |
6 | 05/02/2020 | 1 |
ID | Dates |
1 | 05/02/2020 |
1 | 07/02/2020 |
2 | 05/02/2020 |
3 | 06/02/2020 |
5 | 07/02/2020 |
6 | 05/02/2020 |
Solved! Go to Solution.
pls set the ID column to TEXT or try below DAX
Column =
var _check=maxx(FILTER(Table2,'Table 1'[ID]=Table2[ID]&&'Table 1'[Date]='Table2'[Dates]),Table2[ID])
return if(isblank(_check),0,1)
Proud to be a Super User!
Hello, @ryan_mayu and thank you for your answer. It seems i got an error: "DAX comparison operations do not support comparing values of type Integer with values of type Text". I've check whay type of data are both of the column, Whole number and Date. Do you have any idea what should i do?
pls set the ID column to TEXT or try below DAX
Column =
var _check=maxx(FILTER(Table2,'Table 1'[ID]=Table2[ID]&&'Table 1'[Date]='Table2'[Dates]),Table2[ID])
return if(isblank(_check),0,1)
Proud to be a Super User!
pls try this
Column =
var _check=maxx(FILTER(Table2,'Table 1'[ID]=Table2[ID]&&'Table 1'[Date]='Table2'[Dates]),Table2[ID])
return if(_check="",0,1)
pls see the attachment below
Proud to be a Super User!
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |