BakhtawarPost Patron6 years agovariable in formula hi all first i am going to you what i have in qliksense i create a varaible VPEDate.. in that i do this =if(GetSelectedCount(PE_DATE)>0,Date(Max(GetFieldSelections(PE_DATE))),Date(max(PE_DATE))) ...Show More
BakhtawarPost Patron6 years agook but how i rewrite this in DAX ( RangeMax(0,RangeMin(( POLICY_END_DATE-POLICY_EFFECTIVE_DATE+ 1),(Date(vPE_Date) - POLICY_EFFECTIVE_DATE +1))) ) / (POLICY_END_DATE-POLICY_EFFECTIVE_DATE+ 1) Icey
IceyCommunity Support to Bakhtawar6 years agoHi Bakhtawar , Does the above expression work? Best Regards, Icey
