Forum Discussion
Adding conditional column from different tables and different criteria
Hello All, I am quite new to Power BI. This is going to be my first post to PBI community. I am trying to create a new column which name is history_funnel. After creating this column, I will be ...
Anonymous The new column will need to be created in the Lead History table (the many side of the relationship). You also need to do this NOT in Power Query. DAX is done in the data view in the report. https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-calculated-columns
Your screenshots are of Power Query Editor, which uses M code (not DAX). So many windows and so many languages, it's hard to keep them all straight!