Forum Discussion
DAX
I have a table, Network Name Office Name Status A O1 C A O1 C A O2 C A O6 NC A O3 C B O4 C B O5 NC C O7 C D O8 NC Now I wanted to add a ne...
Hey Anonymous ,
Try :results = Calculate(DISTINCTCOUNT(Table[NameOffice]),Filter(ALL(Table),Table[Network] == EARLIER(Table[Network])
&&
Table[NameStatus] == "C"
))
Best regards,
Hey Anonymous ,
Try :
results = Calculate(DISTINCTCOUNT(Table[NameOffice]),
Filter(ALL(Table),
Table[Network] == EARLIER(Table[Network])
&&
Table[NameStatus] == "C"
))
Best regards,
&&
Table[NameStatus] == "C"
))
Best regards,
Perfect... Thank you