Hi, Guys, Could you please help me with this one? I need to calculate the Week over week sales change in percentage. Sales for current weekday is blank. How we can calculate the total percentage changes without including sales data from previous week if the current weekday sales is blank?
For example, I’d like to show the total sales percentage change as 50% instead of 6.93WoW_change%.pbix (25.4 KB) %.
Thanks!
Mike