Column in expression can be change

[Anonymous]

Hi

I need dynamic column in this DAX using Live connection. eg:- In a table ,if i have selected column from sales table then will show sales amount data and If i have taken column from invoice table then will show invoice data in this below given DAX.

MTD = TOTALMTD(SUM(column),'Calendar'[date])

Thanks,
Varsri

[v-juanli-msft]

Hi @Anonymous 

Currently, it doesn't support to just select the different columns to make it used in a measure/column.

Best Regards
Maggie

[Anonymous]

Hi  Juanli,

        Thanks for reply. but i want dynamic changes in that DAX expression. Suppose if i select YTD, MTD in table with Total Sales, then will show YTD,MTD value according to sales amount and when i select YTD , MTD with invoice sales then show the value according to invoice sales. 

YTD	MTD	Total Sales
	MTD = TOTALMTD(SUM(Total Sales),'Calendar'[date])

YTD	MTD	Invoice Sales
	MTD = TOTALMTD(SUM(Invoice Sales),'Calendar'[date])

Is it possible to create dynamic measure in live connection mode.

Thanks,

Varsri

[v-juanli-msft]

Hi @Anonymous 

I'm afraid it is impossible.

You could create many measures instead.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-juanli-msft]

Hi @Anonymous 

When using live connetion, it doesn't support to create columns in Power BI.

You could create measures instead.

https://radacad.com/live-connection-when-power-bi-comes-hybrid

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.