Note: Click on the headline to open the post in full screen
Writing complex DAX formulas can be a challenging task for many individuals as it involves understanding different concepts and gaining experience. Fortunately, there is a solution that makes it easier.
With the Inforiver Quick formula feature, you can effortlessly add commonly used columns and measures to the matrix visual without writing any DAX code. Inforiver supports 8 quick formulas commonly used in Power BI tabular reports.
Running Total
Rolling Average
% Growth/Decline
% Contribution to Parent
% Contribution to Grand Total
Lead/Lag
Overall Ranking
Ranking Within Group
1. Running total
The Inforiver Quick formula feature allows you to create both calculated columns and measures. You can choose this option when creating a formula in the right panel, as shown below. After that, select the measure on which you want to base your running total calculation.
2.Rolling average
A rolling average smooths out fluctuations over time, providing a clearer trend of values over a specific period.
For examples, By calculating a 7-day rolling average, you can smooth out daily fluctuations and observe the general trend of sales over the past week.
3. % Growth/Decline
The % growth/decline formula is used to calculate percentage changes on a column or measure. Enter the percentage number in the box and use the dropdown to change its sign.
4.% Contribution to parent
"% Contribution to parent" in the hierarchy represents the relative proportion of child values in relation to the parent value. Enabling the bars provides a better understanding of the values, as it helps to visualize the relative proportion of values in relation to the parent's total value.
5.% Contribution to grand total
"% Contribution to grand total" shows the relative proportion of a value within a hierarchy to the overall total. Refer to the calculation shown below.
6. Lead/Lag
The Lead/Lag formula shifts trend data by 'n' periods. These calculations are used to calculate measures such as MoM change and % MoM change.
7.Overall Ranking
The overall ranking is typically used when you want to determine the relative position or order of items across the entire column, regardless of any grouping. For example, it can be used to determine the overall performance of sales representatives.
8.Ranking within group
Ranking within a group is used to determine the position or order of items within specific groups or categories. For examples, You can use to determine the bestselling products within different categories
