Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Building table with % per year

Hi, 
I have follow problem:
He have a table below:

 

I need to build using dax and maybe summarizecolum a table below:

Can someone help me?
Thanks

  • Anonymous , Try a new measure

     

    divide([number of sold], calculate([number of sold], filter(allselected(Table),Table[year] =max(Table[year]))))

1 Reply

  • Anonymous , Try a new measure

     

    divide([number of sold], calculate([number of sold], filter(allselected(Table),Table[year] =max(Table[year]))))