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(I...
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

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

  • Myurathan's avatar
    Myurathan
    Frequent Visitor
    8 years ago

    v-yulgu-msft It works like a charm. Thank you so much.