Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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)
Solved! Go to Solution.
@Anonymous
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)
Proud to be a Super User!
@Anonymous
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)
Proud to be a Super User!
User | Count |
---|---|
121 | |
69 | |
67 | |
57 | |
50 |
User | Count |
---|---|
176 | |
83 | |
69 | |
65 | |
54 |