Forum Discussion
Solved
Card with total based on a condition from calculated values
Hi all, I am trying to create a Key measure that will highlight the % of two values based on a condition. Context: I have two measures, one calculates the Sales of current year and the othe...
You could just use DIVIDE
% diff = DIVIDE( [Current Year], [Previous Year])If either measure returns blank then so will the DIVIDE function
johnt75
Super User
Super UserYou could just use DIVIDE
% diff = DIVIDE( [Current Year], [Previous Year])If either measure returns blank then so will the DIVIDE function