Forum Discussion
Helper IComplex Dax use case
Community Championwhat are you struggling specifically, bringing all the requirements together? also can you provide the data in text format not a screenshot.
Rachel_123The part I am strugging with is when the project has 2 or more expense categories with 5%, I am able to get a result if it's just one expense category bigger than 5%:
Final flag = if([Flag with multi expense] =TRUE(),if(Varince %>5 && Variance in $ <85000,"Y","No"),"No")Project
Date
Expense Type
Variance in $
Variance in %
ABC
4/3/2023
X
93000
6%
ABC
3/3/2023
Y
70000
10%
ABC
4/3/2023
Y
5000
1%
KLM
2/3/2023
Z
12000
2%
MNO
4/3/2023
X
6500
7%
EFG
2/3/2023
Z
50000
10%
EFG
4/3/2023
M
60000
12%
EFG
3/3/2023
Y
1000
3%
- vanessafvg
as i am going through this i am little confused about your conditions;
for multiple rows must all expenses associated to that project be >= 5% or just >5% and < 85000 or <=85000
for a single row is it > 5% and < 85000?
I am trying to under why these 2 rows dont qualify for flagging.
- Rachel_123
Not all rows, if 2 or more rows associated with that project have more than 5% and those same rows are under 85000. Because Project ABC have a row that has over 5% ( first row 6%) and 93000 it shouldn't show up on the list.