Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Guys,
I need your help
I'm trying to input a MoM share growth measure on a PBI Matrix, but I can't . Can you help?
Example:
Month 1: 5% share
Month 2: 10 % share
Desired output:
Example:
So in Month 2 in the column MoM Cat 1 should be: (Past - Present) / (Present) or ( 0.05 - 0.10) / 0.10 = 50% growth
Sample File:
Thanks a lot
Solved! Go to Solution.
Hi @carlovsky ,
Sorry for that I could access your sample file. You could refer to this blog to learn How to provide sample data in the Power BI Forum
But I have built a data sample to test:
1. Assume MS% is the column not a measure
2. Add a Date column for calulation later
Date = DATE(LEFT([Year/Month],4),RIGHT([Year/Month],2),1)
Then according to my understanding, your expected output may like this:
If so, please try:
MoM Cat 1 =
var _pre=CALCULATE(SUM('Table'[MS%]),PREVIOUSMONTH('Table'[Date]),ALLEXCEPT('Table','Table'[Brand],'Table'[Bi Cat 1]))
return DIVIDE( _pre-SUM('Table'[MS%]), SUM('Table'[MS%]))
Output:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @carlovsky ,
Sorry for that I could access your sample file. You could refer to this blog to learn How to provide sample data in the Power BI Forum
But I have built a data sample to test:
1. Assume MS% is the column not a measure
2. Add a Date column for calulation later
Date = DATE(LEFT([Year/Month],4),RIGHT([Year/Month],2),1)
Then according to my understanding, your expected output may like this:
If so, please try:
MoM Cat 1 =
var _pre=CALCULATE(SUM('Table'[MS%]),PREVIOUSMONTH('Table'[Date]),ALLEXCEPT('Table','Table'[Brand],'Table'[Bi Cat 1]))
return DIVIDE( _pre-SUM('Table'[MS%]), SUM('Table'[MS%]))
Output:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |