D365 Finance & Operations and Dynamics AX Forum

Back to discussions
Expand all | Collapse all

#powerbi #BI and Reporting

  • 1.  #powerbi #BI and Reporting

    Posted 24 days ago
    Hello all

    I have the below code as a calculated column, however when i try to create a relationship between project transaction table and Activity table i am getting circular dependency error, any idea how to solve this


    =If([Proj Trans Type]="On-account" && 'Project Transactions'[FK_Activity_Id]=-1,CALCULATE(FIRSTNONBLANK(Activity[Id],1),
    filter(all ('Activity'),Activity[Purpose Level] =1 &&
    'Project Transactions'[FK_Project_Id] = 'Activity'[FK_Project_Id])),'Project Transactions'[FK_Activity_Id])

    Thanks
    Amal

    ------------------------------
    Amal Sheikh Hasan
    Danish Refugee Council
    Copenhagen
    ------------------------------


If you've found this thread useful, dive deeper into User Group community content by role