Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
ND
Can anyone help me to build the dax formula which can avoid the circular dependency? This is quite difficult because it include the recursion. But I think it can be solved because my answer are correct until the sixth month.
NP_B = Obtained the data from the Excel
ND_B = Obtained the data from the Excel
NS_B = Obtained the data from the Excel
NP = Previous ND+PreviousNS
ND = ND_B * (NP_R/NP_B-1)
NS = (NP_R*%)/3
NP_R = NP_B + NP
Can help me to build the dax formula for NP, ND, NS, NP_R to avoid circular dependency? Thanks a lot!!!
The picture are what I did. I did for the temp table, columns and measure. The picture below just one part of that. Hope that can be simplify too.
The pic (Pic with handwriting) above is the columns that I used to build the calculation. "Temp" and "R" in V and V2 are calculated by measures and the remaining are calculated by the new columns
Hi @MiXiang
Not on picture from your pbi, but in your text. Check yellow. Hope this help, kudos appreciated.
Proud to be a Super User!
Yup. NP_R used by ND and NS. Previous ND and NS sum up will be the NP. Previous NP and NS involve the recursion. This caused the circular dependency was detected in "Temp R 2": V2[NS]. I used "Temp NP 2"+NP_B. My month will from 1 to 12.
The pic above is the columns that I used to build the calculation. "Temp" and "R" in V and V2 are calculated by measures and the remaining are calculated by the new columns
Hi @MiXiang is this solution, if yes accept it.
Proud to be a Super User!
Hi. Maybe you can see my replies above again so that you can understand. I think I gave more detailed explanation