Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

PowerBI sum in a matrix

For example, let's say i have a table of daily sales 1Jan 2022 to 31 Dec 2024. and a separate table of daily sales for 2019. 1 jan 2022 to 31 Dec 2022 maps to 1 jan 2019 to 31 dec 2019 1jan 20...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  Anonymous ,

 

Here are the steps you can follow：

1. Create measure.

Measure =
var _table=
SUMMARIZE('Table','Table'[Date].[Year],"Value",[2019 sales])
return
IF(
   HASONEVALUE('Table'[Date].[Year]),[2019 sales],SUMX(_table,[2019 sales])
    )

2. Result:

 

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly