Forum Discussion
Filter the current month
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.
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
2 Replies
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 )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
