Forum Discussion
Remove Duplicates
Hi,
This M code should let you comobine text with number
=Text_column&Number.ToText(Numeric_column)
Replace Text_column and Numeric_column with your actua table and column names.
I know but I want to create a new column using my post code and state. Then I want to remove the duplicates. In transform tab I cannot combine state and postcode together because one is text value and other one is number value.
How can I combine those two columns in tranform tab?
Hi,
This M code should let you comobine text with number
=Text_column&Number.ToText(Numeric_column)
Replace Text_column and Numeric_column with your actua table and column names.
can you please provide it with example.
using the column names. One column is "post code" other one is "state".
Thank you so much I found it.
You are welcome.
Hi,
Is there any way that I can get the average of sales according to that state and postcode column.
I want to get the average if because there are duplicate values in state and postcode column. So I want to get the average of all the NSW2019 COLUMN.
How can I do that.
I used below in Data tab and it worked. How can I do it in transform tab?
Average Sales = CALCULATE(AVERAGE('Sales'[Sales]), FILTER('Sales','Sales'[PostCode and State] = EARLIER('Sales'[PostCode and State])))