Forum Discussion
Iculi
2 years agoFrequent Visitor
QoQ calculation
Hi, How can I create measure to calculate QoQ% i already have this PQ or Actual Q measure which is 2,173 but i don't know how can is create the previous quater data which is 1,930.. Could you plea...
- 2 years ago
Hi,
PBi file attached.
Iculi
2 years agoFrequent Visitor
| Commission Month | LOIs |
| Jan-23 | 390 |
| Feb-23 | 724 |
| Mar-23 | 685 |
| Apr-23 | 693 |
| May-23 | 684 |
| Jun-23 | 748 |
| Jul-23 | 649 |
| Aug-23 | 653 |
| Sep-23 | 838 |
| Oct-23 | 439 |
| Nov-23 | 1,319 |
| Dec-23 | 359 |
| Jan-24 | 495 |
| Mom% | QoQ% | YoY% |
| 37.9% | 12.6% | 26.9% |
| Actual Q | 2,173 | |
| PQ | 1,930 |
AmiraBedh
2 years agoSuper User
Can you please share the formulas you are using for each measure?