Setting up a matrix or table

Hi AndreasRom ,

Due to the design, Power BI Desktop will render slightly differently than Excel.

According to your description, here are my steps you can follow as a solution.

(1) We can create a measure. 

Measure = var _thismonth=FILTER(ALL('Table'),[Entrence flow]=MAX([Entrence flow])&&YEAR([date])=YEAR(MAX([date]))&&MONTH([date])=MONTH(MAX([date])))
var _lastmonth=FILTER(ALL('Table'),[Entrence flow]=MAX([Entrence flow])&&YEAR([date])=YEAR(MAX([date]))-1&&MONTH([date])=MONTH(MAX([date])))
return 
IF(SUMX(_lastmonth,[Value]) <>BLANK(),
DIVIDE(SUMX(_thismonth,[Value])-SUMX(_lastmonth,[Value]),SUMX(_lastmonth,[Value]))+1,BLANK())

(3) Then the result is as follows.

Best Regards,

Neeko Tang

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

AndreasRom , it should be possible to render that table (probably by utilizing matrix in PowerBI) you requested with a high resemblance, but that would require A LOT of DAX writing (you may regard that as writing formula in Excel), as well as utilizing relationships between your data and some role-play tables.

I have previously done something similar which requires me to do all these and it takes me many many times to figure out the way.

The good news is that I have mimicked the matrix you want, and have uploaded that for your reference. This is complicated, just be warned.

Data:

https://drive.google.com/file/d/1FDHMMyPPSm9PLgXtZLjxiGLCu61n4ovT/view?usp=share_link

PowerBI:

https://drive.google.com/file/d/1FDHMMyPPSm9PLgXtZLjxiGLCu61n4ovT/view?usp=share_link