% change calculation showing blanks

[anchal98]

I have a date table running longer since I have forecasts included as a separate fact table but when I'm trying to calculate percentage change in another fact table (sales) I am getting a lot of blanks as the dates are showing from 1990 - 2028 I only need the actual % values to show

[dharmendars007]

Hello @anchal98 

Its difficult to check the calculation without measure and Sample table..

However You can try this mesure below and change the column and measure name according the names you have in your model..

Measure = If(Isblank(Percent Calc), Blank(), [Percent Calc]))

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[anchal98]

the measure is not working. this is the data created with this formula : 

QoQ GROWTH RENT% = DIVIDE([Average Rent], CALCULATE([Average Rent], DATEADD('Dim date'[Date].[Date],-1,QUARTER))

[dharmendars007 · Accepted solution]

Hello @anchal98 , 

Please try this below revised formula..

Measure = 
If(Isblank([Average Rent]), Blank(), 
QoQ GROWTH RENT% = DIVIDE([Average Rent], CALCULATE([Average Rent], DATEADD('Dim date'[Date].[Date],-1,QUARTER)))

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

Thank You

Dharmendar S

LinkedIN