Forum Discussion

cmckinney's avatar
cmckinney
Helper IV
5 years ago

IF statement not recognizing table

I am writing an if statement in a measure that says essentially: IF( 'table'[this_date] > 'table'[that_date], 1, 0) but for some reason Power BI is not recognizing the table/columns. The table refere...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi cmckinney 

Stanislav_dugas and PhilipTreacy 's reply is helpful. Your dax statement will work well in calculated column instead of measure. Measure will return to aggregation, you need to use max function to get date value.

For more details about difference between measure and calculated column you may refer to blogs as below:

Calculated Columns and Measures in DAX

Calculated Columns vs Measures

Could you tell me if your problem has been solved? If it is, kindly Accept the helpful reply as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

 

Best Regards,

Rico Zhou