Forum Discussion

tempranello's avatar
tempranello
Advocate I
10 years ago
Solved

Cyclic relationship

Hello there   I manage a business that runs a service desk.  Currently there is no integration between our timesheet system and our support ticketing system.  People therefore record their support ...
Need Help
  • ImkeF's avatar
    ImkeF
    10 years ago

    Looks totally allowed in my eyes :-)

    That way you break the refresh-chain. Cannot think of any relevant pros/cons here.

ImkeF's avatar
ImkeF
Community Champion
10 years ago

There might be a solution for the order of queries out now, but I'm not aware of it.

 

As a workaround you can continue with (the reference to) your Journal-query within moderation factor lookup query (so instead of ending it, you just create a new step):

 

Journal=Journal,

 

and go on there. As every stepname is a variable, you can just reference your moderation factor by using the last step name you have now.

  • tempranello's avatar
    tempranello
    Advocate I
    10 years ago

    Hi there

     

    Thanks for that prompt reply.  I'm afraid I don't understand.  Can you explain in a little more detail?

     

    I also found a workaround that may get me out of trouble.  It's not ideal as it's using DAX in the main Power BI Desktop window, but it seems to work:

     

    Using the Relationships view I created a relation ship from Journal.Week ending to moderation factor lookup.Week ending.  Back into the Desktop's Data view I then added a column: 

     

    Moderated effort (hrs) = 'Journal'[Effort]*RELATED('moderation factor lookup'[moderation factor])

     

    Is there a disadvantage to using DAX for this?  I feel mildly dirty having stepped out of Power Query to do it, but perhaps that feeling is without basis.

    • ImkeF's avatar
      ImkeF
      Community Champion
      10 years ago

      Looks totally allowed in my eyes :-)

      That way you break the refresh-chain. Cannot think of any relevant pros/cons here.

      • tempranello's avatar
        tempranello
        Advocate I
        10 years ago

        Thanks.

         

        I'll keep an eye out for further releases of Power BI Desktop to see if the sequencing behaviour changes.  In the meantime I'll stick with my DAX :-)