Forum Discussion
If statements - limitations
Hi Kergofil
You can do a join (Merge Queries) on the 2 tables. Pulling the Area Code into the Data table where you only have the Post Code.
See this PBIX file for examples.
If you can supply your data I can implement it for you.
Regards
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Hi Philip ,
well actually I am using data straight forward connecting with the SQL server so I need my data to be dynamic and "live"... so I guess if I would use an excel table to create a new query and then merge it , then when I would try to share the report with other users that wouldnt be possible if I have my PC shut down...right? So, I was thinking to use maybe the M language to write many if statements or any other solution. I also tried to use customize column writing so many IF statements but in the end the message I got was "this query is too complicated to run"... I think there is a limitation also here on the number of IF statements... 😞 If any other solution or idea exists please share. Thank you again
Hi Kergofil
So you are loading data from SQL Server running on your PC?
Whether you use a lot of if statements in a custom column, or have 2 tables and merge them, you are still getting data from the same place and subject to that data being available.
Regards
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.Yes Phil,
Thats correct. I am loading data from SQL server where there I have only a column with the post code (table A). On the other, I have an excel workbook in my PC where I have post code with the Area name (table B). So merging these two tables it would work fine but only when I keep on my PC other users when sharing the report could see the results. So am looking if there is another way to find a solution... Thanks again
