Forum Discussion

basirve's avatar
basirve
Helper 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 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
 

 

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super 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])

  • basirve's avatar
    basirve
    Helper III
    4 years ago

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