cancel
Showing results for
Did you mean:
Regular Visitor

## Circular dependency in columns with different dates

Hello,

I am trying to recreate a relatively easy calculation in Excel in PowerBI. However, it returns a circular dependency.

In Excel, I don't have this issue as, although I use data from the same column, I am using a different row. I have tried to use the calculate function as it is proposed in previous posts regarding the circular dependency, but with no success.

I have added both an Excel sample and the PowerBI template with my so far calculations for the same sample.

Tasos

4 REPLIES 4
Regular Visitor

## Re: Circular dependency in columns with different dates

Why not do this in Power Query/Editor.

Just create a custom column, and you can do all sorts of calculations

Community Support Team

## Re: Circular dependency in columns with different dates

Hi @Tasos,

We can create measures to work on it, then we will get no error.

`awd0m = CALCULATE(SUM(Table1[Demand]))`
`awd1m = CALCULATE(SUM(Table1[Demand]),DATEADD('Table1'[Date],-1,DAY))`
`awd2m = CALCULATE(SUM(Table1[Demand]),DATEADD('Table1'[Date],-2,DAY))`
`CWD2M = IF(ISBLANK([awd1m]),BLANK(),IF(MAX(Table1[Capacity])>[awd2m],[awd2m],MAX(Table1[Capacity])))`

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor

## Re: Circular dependency in columns with different dates

@TasosI agree with you solution, if the original data is still required otherwise cut down the on the data loaded into the report when possible.

Regards,

Mathew

Regular Visitor

## Re: Circular dependency in columns with different dates

Unfortunately, your approach was not what I am looking for. I am currently trying @101Mathew's solution working in Power Editor, although I am not sure how this can help.

Thank both of you for your time,

Tasos