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?
That's much better information. Thanks.
--
What is the desired result for Column In? - please show for the first few rows.
You state "only formula I have gotten to get results are" - are these the right results?
Column In is diplayed in the previous picture in desired way, a 1 in the column if the row is of an "In type"
Then aggregate all In values based by date and time, in the example table I would like to see this result:
Summing up all of the ins for the date, as well as add an out summary as well.
So I get it to work up until adding the same feature for the outs.
Just thought of that both "In" and "Out" would have 1 as value in all rows if what I plan works.
There will always be one in move and one out move per row.
Might be here that my mind tricks me and there is a better way of doing it.