Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Can anyone give me suggestion that why "A circular dependency was detected: SalesTran[Column], SalesTran[SalesYTD], SalesTran[Column]." this error I am getting while calculating MTD?
Function I am using is SalesMTD = CALCULATE(SUM(SalesTran[Amount]),DATESMTD('Calendar'[DateKey].[Date]))
Thanks,
Anupam
Also I am using YTD = CALCULATE(SUM(SalesTran[Amount]),DATESYTD('Calendar'[DateKey].[Date],"03-31"))
In above function there is a slide variation in total amount. In excel it X and in calculated field it is X+1. I don't what is wrong into this.
It this a measure or a calculated column? In the second case, I would expect you to get this kind of error.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |