Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone,
Hope you good, i need your help please about an issue :
I have the same "IdRetour" for different reference, and i want if one of "PriseEnGarantie" is False all the reference return False, the three IdRetour "107" is false.
Thank for the futur answer, and sorry if my english is not that good.
Good Day
@ItSupportElm , Create a new column as
new column =
var _cnt = countx(filter(Table, [IdRetour] = earlier([IdRetour]) && [PriseEnGarantie]=false()),[PriseEnGarantie])+0
return
if(_cnt >0, false(), true())
Thank you for ansering o quickly @amitchandak , i try your formula but it didnt work im in direct query i dont know if it change anything.
here the error :
User | Count |
---|---|
60 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
86 | |
54 | |
54 | |
38 | |
21 |