topic Re: Replace the value Based other column particular market in DAX Commands and Tips

Replace the value Based other column particular market

Anonymous — Thu, 19 Jan 2023 11:10:42 GMT

I have the table name called Global POL. this table have three column . i am trying to replace the packtype value for particular market UA04 .this market vakue trying to set null value value. when i use replace value its changed for the all market

Market packtype

UA04 SOFTPACK

UA04 REMARK

CA04 SOFTPACK

CA04 REMARK

MA04 SOFTPACK

MA04 REMARK

Expected Output:

UA04

CA04 SOFTPACK

CA04 REMARK

MA04 SOFTPACK

MA04 REMARK

Looking for support . thanks in advance .

Re: Replace the value Based other column particular market

FreemanZ — Thu, 19 Jan 2023 12:05:08 GMT

hi Anonymous

try to create a calculated column like this:

column = IF([Market]<>"UA01", [packtype])

Re: Replace the value Based other column particular market

jaweher899 — Thu, 19 Jan 2023 12:30:47 GMT

One way to achieve this in Power BI is to use the FILTER and IF functions together in a calculated column. You can create a new calculated column called "Packtype_Filtered" and use the following formula:

=IF(Global_POL[Market] = "UA04", BLANK(), Global_POL[Packtype])

This formula checks if the value in the "Market" column is "UA04", and if so, it returns a blank value. If not, it returns the original value from the "Packtype" column.

Alternatively, you can also use the SWITCH function to check for different market values and replace the packtype value accordingly:

=SWITCH(Global_POL[Market], "UA04", BLANK(), Global_POL[Packtype])

This function checks the market value, and replaces the packtype value based on the market value.