Forum Discussion
Circular dependency - Odd table
It's better to 'show' what you're doing rather than explain it in words (sometimes both are required). A small test data sample with the DAX for the calculated columns.
--
The error message says - CSV[Column] depends on CSV[Out] which depends on CSV[Column]. There might be no explicit connection between these two to the untrained eye but powerbi sees a connection.
Let's look at the column code you have provided:
Out = calculate(sum(CSV[A Out]) + sum(CSV[B Out]) + sum(CSV[C Out]) + sum(CSV[D Out]) + sum(CSV[E Out]) + sum(CSV[F Out]) + sum(CSV[G Out]) + sum(CSV[H Out]) + sum(CSV[I Out]))
This looks like it could be done simpler. Why is the calculate there? Is the SUM keyword required? Can you show what you are trying to do here (with an example) please?
Can we focus on the calculated column DAX please?
Can you answer my question on the Out column?
--
You don't need to be cryptic when posting questions on the forum. Put a small sample data set together. Show what you have. Show what you want. Describe briefly what you are trying to do.
Thanks for your patience, realize I probably should take a DAX-course.
Last shot:
Data file
Adding columns
Creating summary table
Needing a summary for outs and ins per day. Adding new column(s)
The only formula I have gotten to get results are:
Using sum function to get all values added per date
But when doing the same for Out the circular issue occurs.
Sorry for pictures in stead of proper way to give you the codes and swedish as the program language but hope it gives an idea of what I am after.
I probably have made some mistakes not using proper DAX which I am not too familiar with yet. At least I hope this shows what I am after.