Forum Discussion

AllanBerces's avatar
AllanBerces
Post 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! 

2 Replies

  • AlexTheGreat's avatar
    AlexTheGreat
    Resolver II
    1 year ago

    Hi,

    Just add a if statement in your dax

     

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

    Hope it helps!