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!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

A clarification: but the dates in [start] and [end] are only by chance the beginning and the end of the month or is it always like this?

 

Could you upload in somewhere a file (excel?) containing the examples table?