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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
TimoMeyer
Frequent Visitor

Table Column not recognized in IF-Statement

Hello everybody, 

 

I would like to create an IF-Statement based on the month. But when I type it in like this it always return an error. Any way to fix this?

 

Measure = 

IF('IMTT: MASTER TABLE'[Year_Month] = "2023/01", 1, 2)

 

TimoMeyer_0-1680248830052.png

 

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@TimoMeyer 

you can try this

 

Measure = 

IF(SELECTEDVALUE('IMTT: MASTER TABLE'[Year_Month] )= "2023/01", 1, 2)

 

OR

 

Measure = 

IF(MAX('IMTT: MASTER TABLE'[Year_Month]) = "2023/01", 1, 2)

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
ryan_mayu
Super User
Super User

@TimoMeyer 

you can try this

 

Measure = 

IF(SELECTEDVALUE('IMTT: MASTER TABLE'[Year_Month] )= "2023/01", 1, 2)

 

OR

 

Measure = 

IF(MAX('IMTT: MASTER TABLE'[Year_Month]) = "2023/01", 1, 2)

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors