Forum Discussion

Dudeman's avatar
Dudeman
Helper I
5 years ago
Solved

fixing circular reference in calculated column

Hello.    I'm getting a circular reference I can't figure out how to fix when creating a calculated column version of a calculated measure. Here is my workbook Airport code workbook (wetransfer li...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    5 years ago

    Hi Dudeman   ；

     

    When you use Live connection, you can not add columns,  So maybe you could try to modify the MaxArrival2 column by the following formula:

    MaxArrival2 =
CALCULATE (
    MAX ( 'Legs'[arrivalTime] ),
    FILTER (
        ALL ( 'Legs' ),
        [BookingNumber] = EARLIER ( [BookingNumber] )
            && [ArrivalDate] = EARLIER ( [ArrivalDate] )
    )
)

    The final output is shown below:  

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.  

HotChilli's avatar
HotChilli
Community Champion
5 years ago

The first thing to do is to rewrite the column DAX so it's not using a measure i.e. [MaxArrival].  A calculated column should not use a measure (it's possible to do it but definitely not advisable)

 

Edit: I've just seen that [ArriveConnect] is a measure too so same advice applies.

Dudeman's avatar
Dudeman
Helper I
5 years ago

Thanks HotChilli. Do you know how I could re-write the DAX? I'm very new to all of this.

I'm not too sure how to re-write it becuase I need to be able to still reference something like MaxArrival and ArriveConnect to get my end result, don't I?