Setting up a matrix or table

[AndreasRom]

Hello everyone, 

I am new at Power BI (read 14 days of working) and is try to transition from Excel to PowerBI. I have already experienced the PowerBI compared to Excel, but has run into some issues, that I can't figure out if is even possible to create in Power BI. 
In Excel I have made the following (see picture), to follow the growth each month. Is it possible to make a structure simular to this in Power BI? 

Thank you for taking your time reading this 🙂 

[Anonymous · Accepted solution]

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. 

[johnyip · Accepted solution]

@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

[AndreasRom]

Thank you SO MUCH for your help, and taking you're time making this! I have never figured this out myself. 😄 

[Anonymous · Accepted solution]

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]

Hey! Thank you so much for sharing your solution! It was a massive help! 😄