Forum Discussion
% change calculation showing blanks
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
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
3 Replies
- dharmendars007
Memorable Member
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
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
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
