Forum Discussion

Bakhtawar's avatar
Bakhtawar
Post Patron
6 years ago

variable 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))) ...
Need Help
Show and Tell
Tutorial Requests
Icey's avatar
Icey
Community Support
6 years ago

Hi Bakhtawar ,

Sorry to reply late. Please check if the below expression is the first one you want. Several others will take some time.

 

 

VPEDate =
IF (
    COUNTAX ( Calender, SELECTEDVALUE ( Calender[Date] ) ) > 0,
    MAXX (
        FILTER (
            ALL ( Calender ),
            YEAR ( SELECTEDVALUE ( Calender[Date] ) ) = Calender[Year]
                && MONTH ( SELECTEDVALUE ( Calender[Date] ) ) = Calender[Month]
        ),
        Calender[Date]
    )
)

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Bakhtawar's avatar
    Bakhtawar
    Post Patron
    6 years ago

    ok 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 

     

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi Bakhtawar ,

     

    Does the above expression work?

     

    Best Regards,

    Icey