Forum Discussion

basirve's avatar
basirve
Icon for Helper III rankHelper III
4 years ago

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...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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])