Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |