Forum Discussion

GunnerJ's avatar
GunnerJ
Icon for Post Patron rankPost Patron
6 years ago
Solved

Produce a message based on supplied date

I need to check the start date for the filter and if it's less than the current January 1st of the current year produced a message. Otherwise I want it blank. Below is my current attempt but it just ...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi GunnerJ ,

    Create your measure like so:

    Post Date Message =
VAR startdate =
    CALCULATE (
        MIN ( GL_TRAN_ACT[GL_POST_DT] ),
        ALLSELECTED ( GL_TRAN_ACT[GL_POST_DT] )
    )
RETURN
    IF (
        startdate < DATE ( YEAR ( TODAY () ), 1, 1 ),
        "Equity % of Asset Visual only calculates on or after the start of the current year",
        ""
    )

    Best Regards,

    Icey

     

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

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

Hi GunnerJ ,

Create your measure like so:

Post Date Message =
VAR startdate =
    CALCULATE (
        MIN ( GL_TRAN_ACT[GL_POST_DT] ),
        ALLSELECTED ( GL_TRAN_ACT[GL_POST_DT] )
    )
RETURN
    IF (
        startdate < DATE ( YEAR ( TODAY () ), 1, 1 ),
        "Equity % of Asset Visual only calculates on or after the start of the current year",
        ""
    )

Best Regards,

Icey

 

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