Forum Discussion
Recursive Dax Formula
Dear Expert, I am new to Power BI, read some articles on Recursive formulas in BI, but found that it is a bit of a hac. I want to create a formula shown in yellow highlighted in Excel as same...
Hi TusharM09 ,
Please see the attached and take note of the following:
Formula is only for runing sum of Factorial Corpus- it is unclear whether you want to do it for the units as welll as it hardcoded in your sample file but a similar formula can be used.
I created two measures - one uses the fact dates and the other a separate dates table. It is always a good practice to use a separate dates table for time intelligence calculation. You might see unexpected results if you start adding another dimension column to your visual if a separates table is not used.
