Forum Discussion

Kokogbiya's avatar
Kokogbiya
Regular Visitor
3 years ago

% Rolling Trend

Hello Gurus,    Kindly help me on how to complute the % movement vs previous years, with reference to the below table.    for example, in February,I should be able to see below Feb (+-5% movement...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Kokogbiya ,

What's your expected result? Do you want to the get the sum of value but the total values display the percentage on the matrix? Could you please provide some raw data in your fact table (exclude sensitive data) with Text format and your expected result with calculation logic and special examples? It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

Kokogbiya's avatar
Kokogbiya
Regular Visitor
3 years ago

Thank you Anonymous  for the response. 

 

please see below data set in text, and a PBI link. 

 

https://www.dropbox.com/t/JX25xQ1D1HV6mJpE 

 

MaterialRoundJan-23Feb-23Mar-23Apr-23May-23Jun-23Jul-23Aug-23Sep-23Oct-23Nov-23Dec-23
PencilJan-23          626          712          682          686          753          684          625          873          772          691          902          811
PencilFeb-23           564          619          657          618          348          627          618          583          495          693          683
PencilMar-23            599          643          681          742          712          659          600          604          687          624
PencilApr-23             643          681          742          712          660          617          641          643          633
PencilMay-23              681          681          673          638          602          657          615          631
PencilJun-23               714          658          815          857          888          859          830
PencilJul-23                658          815          857          888          859          830
PencilAug-23                 815          857       1,238       1,218       1,209
PencilSep-23               1,217       1,211       1,211       1,207
PencilOct-23                1,211       1,224       1,169
PencilNov-23                 1,224       1,172
PencilDec-23                  1,172

 

 

The expected result is to represent this table on power BI, with being able to calculate the % formatted volume movement month-on-month. 

 

the calculation logic is *% volume movement "rounds vs month" i.e, Jan -Feb moved from 626-564 (-10%), Feb - Mar moved 564-599 (+6%) etc 

 

 

 

Br,

Kingley..