i am new on powerbi. i am getting this error. Here is below my table.
|GName||Year||Opening Stock||InQty||initemvaluee||Average Value||Closing Stock Value||Opening Stock Value|
I am taking average from below dax
Average Value = (([initemvaluee]+[Opening Stock Value])/([inqtyy]+[Opening Stock]))
i want the closing stock value previous year in the field of opening stock value. but it gives me error of
A circular dependency was detected
Please help how it will
Do you call measure when you create a calculated column?Maybe you could consider creating a measure or re creating the corresponding calculated column from the previous measure
i have tried all but all in vain if you want the file i am attaching.
Check out the News & Announcements to learn more.
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!