The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
hi
want to use a simple statement but in the advanced editor of query editor i seems to be missing something....
this is what i have:
Account groups= 999999, 90000 and 87000 plus we have an costcenter in range 240, 200, 250, 300, 270, 777
so if the Account group is 999999 AND the costcenter is in range of 200, 240, 270 then B1. Automatic else NULL
Tried this so far, unfortunately without succes...
if [Account Group] = "999999" and [Costcenter] in ('200', '240', '270') then B1. = failed
if [Account Group] = "999999" && [Costcenter] in ('200', '240', '270') then B1. = failed
any ideas?
thanks!
M
Solved! Go to Solution.
HI @emveha
Try this
if [Account Group] = 999999 and List.Contains({200, 240, 270},[Costcenter] ) then [B1] else null
If the Columns Account Group and Costcenter are of Text Type then use ""
if [Account Group] = "999999" and List.Contains({"200","240", "270"},[Costcenter] ) then [B1] else null
HI @emveha
Try this
if [Account Group] = 999999 and List.Contains({200, 240, 270},[Costcenter] ) then [B1] else null
If the Columns Account Group and Costcenter are of Text Type then use ""
if [Account Group] = "999999" and List.Contains({"200","240", "270"},[Costcenter] ) then [B1] else null
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
82 | |
64 | |
58 |
User | Count |
---|---|
248 | |
123 | |
112 | |
79 | |
78 |