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...
Hey danextian,
you are on the correct path so happy.
I have been working on this for the last two weeks and now found some hope.
Ans. to your question...
1) yes I want the formula on unit Nav too ( NAV value / FC of the date)
2) The formula of FC is divided into three parts = (Total Corpus of current date / Unit Nav of Last date)+FC of last date
3) in my main model I have used a separate calendar table
4) I have hardcoded it as i don't know how to write it,
Regards,
Tushra M.
You can try this formula:
Unit Nav (Measure) =
DIVIDE ( SUM ( Sheet1[NAV Value ] ), [Factoral Corpus (Calendar)] )
Please note that the corpus numbers in your pbix is 10x than in your Excel file.