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
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!