DAX to Hide Variance number if current year data is Missing

[Anonymous]

Hello,

The table on the left shows Crrrent year and Previous Year Data. THe table on the right shows the Variance between the two fiscal years. From Period 9 to 12 I have to Current Year Data. How can I make my varaince blank for those periods? I tried the DAX formula below but it does not work. 

Variance2 = 
VAR CY = [Current Year]
VAR PY = [Previous Year]
VAR VarianceT = CY-PY
VAR RESULT = IF (ISBLANK (CY),0,(VarianceT))
RETURN Result

[amitchandak]

@Anonymous , Make 0 as blank and try

Variance2 =
VAR CY = [Current Year]
VAR PY = [Previous Year]
VAR VarianceT = CY-PY
RETURN IF (ISBLANK (CY),blank(),(VarianceT))

You can do this for PY measure too, if you want hide the rows. You have do it for all the measures

[Anonymous]

My Current Year and Previous Year are written this way.  

Current Year = if(ISBLANK([Amount]),"$0",([Amount]))//Same as Amount

Previous Year = IF(ISBLANK(CALCULATE([Amount], SAMEPERIODLASTYEAR('Calendar'[Date]))),"$0",CALCULATE([Amount], SAMEPERIODLASTYEAR('Calendar'[Date])))

[Anonymous · Accepted solution]

Nevermind! I seem to have overcomplicated my DAX formulas. This fixes everything, and now my visual excludes periods which cannot be compared! 

Current.YearT = [Amount]
Previous.YearT = (CALCULATE([Amount], SAMEPERIODLASTYEAR('Calendar'[Date])))
Variance2 = if(isblank([Current.YearT]),blank(),[Current.YearT]-[Previous.YearT])
Variance.T% = Divide([Variance2],[Current.YearT])

[Ashish_Mathur]

Hi,

Since CY is a measure, it should be between [].  So try this

=if(isblank([CY]),blank(),[CY]-[PY])

Hope this helps.

[Anonymous]

Unfortunately it di not work. My negative variances caused by No periods in 2020-2021 are still appearing