Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Myurathan
Frequent Visitor

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

 

1 ACCEPTED SOLUTION
v-yulgu-msft
Employee
Employee

Hi @Myurathan,

 

Please try:

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

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yulgu-msft
Employee
Employee

Hi @Myurathan,

 

Please try:

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

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.