The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi guys,
I have encountered some strange circular dependency error which I do not see any connection between each section.
TG (Plan) has already been calculated using plan number - current sales (AOP - CY rev)
I have no idea where is the connection between LE to-go (TG LE) and Plan to-go.
@Alanlu , In case both, are columns try
[Le] - [CY Rev]
@amitchandak It's not working as I expected.
maybe I should explain a bit more regarding the format of the data.
[CY rev] contains multiple posting dates and customer#
[AOP] and [LE] are allocated monthly only.
I would like to see the to-go value va AOP and LE for MTD, QTD and YTD.
Thanks
@Alanlu , Please share the formula
Also, Refer
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
@amitchandak the formula for TG(Plan) is below
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
135 | |
101 | |
89 | |
72 | |
58 |
User | Count |
---|---|
262 | |
120 | |
115 | |
95 | |
82 |