Forum Discussion
Complex Dax use case
I have this complex use case, I need to get a list of projects or flag them in DAX based on the following: - If a project has multiple expense types then flag : The project that ha...
it depends on how you are creating your data, what other calculated columns do you have in your data?
so my table has the following columns
Date, Project, Actuals, Current Budget, Expense Type, Var to budget ($) and Var to budget %
both the Var to budget $ and % are calculated
Var to budget ($) =
if('Projects Summary'[Actuals] <> blank(), ABS('Projects Summary'[Current Budget]-'Projects Summary'[Actuals]),blank())
Var to budget (%) = ABS(DIVIDE('Projects Summary'[Var to Budget],'Projects Summary'[Current Budget]))
But the error I get is that circular dependency between the 2 new columns that you suggested I create, could it be because the % column depends on the $ column?
Var to budget (%) = ABS(DIVIDE('Projects Summary'[Var to Budget],'Projects Summary'[Current Budget]))
But the error I get is that circular dependency between the 2 new columns that you suggested I create, could it be because the % column depends on the $ column?