Forum Discussion
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...
Dear Amit,
In the above logic if POD Calltype Exists then we have to show POD for others Blanks need to Show.
How can we achive that sceneraio, Could you pls suggest your thoughs?
Calculated Colum:
_Test =
IF (
ISBLANK ( Denodo_Primary_Area_Agent_Attribute[_Call Type 4 Characters] ),
MAXX (
FILTER (
Denodo_Primary_Area_Agent_Attribute,
EARLIER ( Denodo_Primary_Area_Agent_Attribute[Disc_Dt] ) >= Denodo_Primary_Area_Agent_Attribute[Eff_Dt]
&& EARLIER ( Denodo_Primary_Area_Agent_Attribute[Disc_Dt] ) <= Denodo_Primary_Area_Agent_Attribute[Eff_Dt]
),
Denodo_Primary_Area_Agent_Attribute[_Call Type 4 Characters]
),
Denodo_Primary_Area_Agent_Attribute[_Call Type 4 Characters]
)