Forum Discussion

Myurathan's avatar
Myurathan
Frequent Visitor
8 years ago
Solved

IF with 2 conditions

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.

 

https://imgur.com/fsFWwPY

 

Need Help
Show and Tell
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Myurathan,

     

    Please try:

    % Change Compared to 2014:=IF(Max(dCalendar[Year])=2014,BLANK(),DIVIDE([Total Net Revenue],[2014 Total])-1)

    Regards,

    Yuliana Gu

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Myurathan,

     

    Please try:

    % Change Compared to 2014:=IF(Max(dCalendar[Year])=2014,BLANK(),DIVIDE([Total Net Revenue],[2014 Total])-1)

    Regards,

    Yuliana Gu