Forum Discussion
basirve
4 years agoHelper III
DAX formula Priority
Dear EXperts, If the POD Call type with in daterange exists then the give priority of them else others Calltype. 1) If the Skill Target ID having 2 Calltypes are 1) POD 2)Other in these case we ha...
amitchandak
4 years agoSuper User
basirve , Nor very clear ,
a new column
=if(isblank([Call Type]), Maxx(filter(Table, earlier(Table[Dts]) >= Table[EF] && earlier(Table[Dts]) <= Table[Dts] ), [Call Type]) , [call Type])