The following table in PBI has price changes. I want to get a table of
a) monthly date-wise weighted average price. maybe i could create a table in PQ for each date in calendar and then group. But how do i do in DAX, since there are many materials.
b) simple average by material with considering first on month price and changes thereafter in the month
c) month end prices by material
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
for example, wgtd avg derived by PQ
<thead>
</thead><tbody>
</tbody>
thanks
nilesh
a) monthly date-wise weighted average price. maybe i could create a table in PQ for each date in calendar and then group. But how do i do in DAX, since there are many materials.
b) simple average by material with considering first on month price and changes thereafter in the month
c) month end prices by material
Date | Material Name | Price |
01/01/2019 | A | 23 |
01/01/2019 | B | 98 |
23/01/2019 | A | 21 |
23/01/2019 | B | 93 |
01/02/2019 | A | 20 |
01/02/2019 | B | 90 |
14/02/2019 | A | 22 |
14/02/2019 | B | 89 |
21/03/2019 | A | 25 |
21/03/2019 | B | 86 |
30/03/2019 | A | 30 |
30/03/2019 | B | 100 |
11/05/2019 | A | 32 |
11/05/2019 | B | 99 |
12/05/2019 | A | 30 |
12/05/2019 | B | 98 |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
for example, wgtd avg derived by PQ
mmm | A | B |
---|---|---|
January | 22.41935484 | 96.5483871 |
February | 21.07142857 | 89.46428571 |
March | 23.38709677 | 88.83870968 |
April | 30 | 100 |
May | 30.06451613 | 98.67741935 |
<thead>
</thead><tbody>
</tbody>
thanks
nilesh