Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Folks,
I am currently building following PowerPivot. Here I am comparing percentage change of Total Revenue compared to 2014 Total Revenue. My measure is
% Change Compared to 2014:=if(ISFILTERED(dCalendar[Year]),DIVIDE([Total Net Revenue],[2014 Total])-1,BLANK())
I want the table to display blank for 2014 %changes. In other words, I want blank on those red marked cells. I tried IF function but it shows ERROR. How can I encorporate in the same measure.
Thanks in advance.
Solved! Go to Solution.
Hi @Myurathan,
Please try:
% Change Compared to 2014:=IF(Max(dCalendar[Year])=2014,BLANK(),DIVIDE([Total Net Revenue],[2014 Total])-1)
Regards,
Yuliana Gu
Hi @Myurathan,
Please try:
% Change Compared to 2014:=IF(Max(dCalendar[Year])=2014,BLANK(),DIVIDE([Total Net Revenue],[2014 Total])-1)
Regards,
Yuliana Gu
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |