Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi experts,
I am new to PBI and of course need some help with queries. When I run the two quries below. I get the error message in the subject line. When I run the first query or the second query ALONE, I don't get the error message. I will greatly appreciate your help.
#"Added Conditional Column1" = Table.AddColumn(#"Added Column", "Instructor_FN", each if Text.Length(ACADEMIC_HISTORY[INST_FIRST_NAME])=0 then ACADEMIC_HISTORY[FACULTY_FIRST_NAME] else ACADEMIC_HISTORY[INST_FIRST_NAME]),
#"Added Conditional Column2" = Table.AddColumn(#"Added Conditional Column1", "Instructor_LN", each if Text.Length(ACADEMIC_HISTORY[INST_LAST_NAME])=0 then ACADEMIC_HISTORY[FACULTY_LAST_NAME] else ACADEMIC_HISTORY[INST_LAST_NAME])
Solved! Go to Solution.
here is an alternative to your code, just replace these line from your code and let me know if it works:
#"Added Conditional Column1" = Table.AddColumn(#"Added Column", "Instructor_FN", each if Text.Length([INST_FIRST_NAME]) = 0 then [FACULTY_FIRST_NAME] else [INST_FIRST_NAME]),
#"Added Conditional Column2" = Table.AddColumn(#"Added Conditional Column1", "Instructor_LN", each if Text.Length([INST_LAST_NAME]) = 0 then [FACULTY_LAST_NAME] else [INST_LAST_NAME])
Blog: AnalyticPulse
Youtube Channel: AnalyticPulse
here is an alternative to your code, just replace these line from your code and let me know if it works:
#"Added Conditional Column1" = Table.AddColumn(#"Added Column", "Instructor_FN", each if Text.Length([INST_FIRST_NAME]) = 0 then [FACULTY_FIRST_NAME] else [INST_FIRST_NAME]),
#"Added Conditional Column2" = Table.AddColumn(#"Added Conditional Column1", "Instructor_LN", each if Text.Length([INST_LAST_NAME]) = 0 then [FACULTY_LAST_NAME] else [INST_LAST_NAME])
Blog: AnalyticPulse
Youtube Channel: AnalyticPulse
It worked !! Thank you so much !! I've struggled with this issue for a while and was going crazy. ha!
Would you mind explaining why this was happening? Just because specifying the table name in two different queries?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
15 | |
13 | |
13 | |
12 | |
11 |