cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
amoljoshi7

Issue with IF function

Submitted by amoljoshi7 New Member on ‎06-20-2019 08:21 PM

Since I have installed June 2019 update of Power BI, the IF function can not resolve the table and column names; when I try to write a measure.

 

I tested the SUM function and it can resolve the table name and columns but IF function can't.

 

I tried uninstalling and reinstalling but it didn't help.

 

Any clues? Thanks.

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
v-qiuyu-msft
Moderator v-qiuyu-msft
Moderator
‎06-23-2019 07:59 PM

Hi @amoljoshi7, 

 

Would you please share some screenshot so we can understand the issue better? 

 

Which DAX do you use to create the measure? When we use the IF() function to create a measure, we need to use aggregation functions inside of the IF() function, eg: count, sum, max,...,etc. 

 

Best Regards,
Qiuyun Yu 

Idea Statuses