Forum Discussion

Kavitha10's avatar
Kavitha10
Frequent Visitor
5 years ago
Solved

Dynamic column creation

Hi All,   Is there any way to dynamically create calculated columns for each of the values stored in the list/table. I have a list/table with values A,B,C, I need to create columns - A with filter...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  Kavitha10 ,

     

    You could do it using dax expression:

    Measure = 
CALCULATE(SUM(Table1[Amount]),FILTER(ALL(Table1),'Table1'[Date]>=MAX('Table2'[Start Date])&&'Table1'[Date]<=MAX('Table2'[End Date])&&'Table1'[Company Name]=MAX('Table1'[Company Name])))

    And you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi  Kavitha10 ,

 

Do you wanna get something as below:

If so,create a measure as below:

Measure = CONCATENATEX(ALLSELECTED('Table'[Value]),[Value],",")

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

  • Kavitha10's avatar
    Kavitha10
    Frequent Visitor
    5 years ago

    Hi, Thank you for the response. Please refer to the above edited query. I have elaborated my requirement.