topic call header coloumn name with coloumn value in DAX Commands and Tips

call header coloumn name with coloumn value

Wicak — Wed, 23 Feb 2022 04:24:22 GMT

i have a problem calling the names of sku coloumns into one coloumn, based on the value every day. have any suggestion? Thanks 😊

Re: call header coloumn name with coloumn value

Anonymous — Wed, 23 Feb 2022 05:56:37 GMT

Hi Wicak ,
You can use a calculated measure like this

SKU Run = SWITCH( TRUE(), NOT(ISBLANK(SUM('Sample Table'[SKU A]))),"SKU A", NOT(ISBLANK(SUM('Sample Table'[SKU B]))),"SKU B", NOT(ISBLANK(SUM('Sample Table'[SKU C]))),"SKU C", NOT(ISBLANK(SUM('Sample Table'[SKU D]))),"SKU D", BLANK() )

Then pull this measure into the table or matrix.

The output looks like this

Regards,

Aditya

Re: call header coloumn name with coloumn value

Wicak — Wed, 23 Feb 2022 09:00:22 GMT

Thanks,

its works. but i didn't use SUM because the result was an error

SKU Run = SWITCH( TRUE(), NOT(ISBLANK('Sample Table'[SKU A])),"SKU A", NOT(ISBLANK('Sample Table'[SKU B])),"SKU B", NOT(ISBLANK('Sample Table'[SKU C])),"SKU C", NOT(ISBLANK('Sample Table'[SKU D])),"SKU D", BLANK() )

Re: call header coloumn name with coloumn value

Anonymous — Wed, 23 Feb 2022 09:05:18 GMT

Hi Wicak, can you tell what error you are facing?

Re: call header coloumn name with coloumn value

Wicak — Wed, 23 Feb 2022 09:18:53 GMT

Sory,

There seems to be a value model in a row that has its own value. so SUM can't work