Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Column in expression can be change

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

Need Help

4 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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. 

       

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

       

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

       

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

       

      Thanks,

      Varsri

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        7 years ago

        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.