DAX formula Priority

[basirve]

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 have to show POD for other call type shows Blank,In case of skilltarget id is not having any POD calltype with in date range then we have to show Same calltype.
How to achive this in calculated column in DAX.

Please call me in case of any issues,

Thanks % Regards,

Venkat

MobWhatsapp:7411002501
 

[basirve]

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

[amitchandak]

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