Forum Discussion

Icon for Helper IV rank

Helper IV

6 years ago

Cap Table Circular Reference

Hello All, I need some help with a circular reference problem that I have been working on for a few weeks. I believe that this can be done, it is just that I am still in the process of learning p...

Tutorial Requests

Icon for Super User rank

Super User

6 years ago

ARob198 , refer if this can help

https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/

HotChilli
Community Champion
6 years ago
I think the DAX formulas will have to be provided and relationships ( if there are more than one table) so we can see what's going on.

Also, have you tried calculating the columns in Power Query?
- ARob198
  Helper IV
  6 years ago
  There is not another table, nor are there any DAX formulas. I am happy to share this excel file if you tell me how to do that on the forum. I am trying to recreate this table and calculations in DAX. What is the difference between doing the calulcations as measures in the desktop and doing them in Power Query Editor? I was under the impression that calculations should not be done in Power Query Editor if at all possible.
  
  Thank you for your help HotChilli
  - HotChilli
    Community Champion
    6 years ago
    I'm slightly confused. Maybe there is a misunderstanding about terminology.
    
    There's a circular reference error (that's the title of the post). There are no other tables. The circular reference must be coming from the DAX formula for a calculated column (probably based on another calculated column). So i'd like to see the DAX formula for (any) calculated columns. Let me know if I've got that wrong.
    
    Power Query is an excellent tool and works beautifully for this sort of thing.
    
    The difference between calculated columns and measures->
    
    https://radacad.com/measure-vs-calculated-column-the-mysterious-question-not