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!

JW_van_Holst's avatar
JW_van_Holst
Resolver IV
5 years ago

I assume you need this result:

 

You need 3 simple queries:

= List.Distinct(Transactions[#"Company Name"])
= #table(Query1,{})
= StartEnd&Query2

Good Luck,

//JW