Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I am new to Power BI and would appreciate your help
I have a table in SQL which I import using Direct query in power BI. I need to create a new column with some simple data manipulations, such as IF(col1 = value && col2 = value && col 3=value, 1, 2)
I expect a new column return 1 or 2 values in each row 1 where condition is true and 2 when condition is not true.
Basically this can be any other values just to distinguish when condition is met and when is not for filtering and count
However it returns a column with random numbers.
Please help!
thnx
Solved! Go to Solution.
Right, so the visualization is summing the column.
Click on the visualization > In the visualizations panel on the right, click the down-arrow highlighted in the picture below > select "Don't summarize"
@tananich I don't see why your IF statement would be returning random numbers. Can you send a screenshot that includes the formula and the table?
@Anonymous
see below
Right, so the visualization is summing the column.
Click on the visualization > In the visualizations panel on the right, click the down-arrow highlighted in the picture below > select "Don't summarize"
@Anonymous right, thnx a lot, dunno how i haven't noticed