Filter the current month

[sarjensystems1]

Hello All,

Need help,

We are getting current year values and last year values, but in current year values we don't have current month values, At the time of "% change" calculation we are getting values as 100% for current month.  we need to show '0' or remove this month from the dax.
For LY Direct Dax is "LY Direct = CALCULATE([Total Net Sales],SAMEPERIODLASTYEAR(Calender[Date]))"
How to achieve this in dax.

 

[v-luwang-msft · Accepted solution]

Hi @sarjensystems1 ,

You could use the following measure:

% Increase_Direct Sales_2=if([% Increase_Direct Sales_1]=-100.00,0,[% Increase_Direct Sales_1])

You can also take the var approach and write this  directly in the % Increase_Direct Sales_1 measure.

Wish it is helpful for you!

Best Regards

Lucien

[Fowmy]

@sarjensystems1 

Add an if condition to check if LY or CY has blank then show Blank else calculate the change:

% Increase_Direct Sales_1 = 

IF(
    ISBLANK([Total Net Sales]) || ISBLANK([LY Direct]),
    BLANK(),
    //Enter your formula for %Change
)