Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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
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
@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
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |