Forum Discussion

AllanBerces's avatar
AllanBerces
Icon for Post Prodigy rankPost Prodigy
1 year ago
Solved

Visual calculation- If

Hi can anyone help me on my visual calculation if the date is greater than today value should be " - ",  Delta = [Actual] - [Plan]   Thank you
Need Help
  • AlexTheGreat's avatar
    AlexTheGreat
    1 year ago

    Hi,

    Just add a if statement in your dax

     

    Delta = 
    IF(     [Date] > TODAY(),
            "-",
            [Actual] - [Plan])

    Hope it helps! 

AlexTheGreat's avatar
AlexTheGreat
Icon for Resolver II rankResolver II
1 year ago

Hi,

Just add a if statement in your dax

 

Delta = 
IF(     [Date] > TODAY(),
        "-",
        [Actual] - [Plan])

Hope it helps!