Forum Discussion

MrLanla's avatar
MrLanla
New Member
5 years ago
Solved

input data range condition with another table

hi , i want to make "new column" in power bi Desktop with related to another table with range condition    first i have releatioship them and what next? for example i have two table 1.    ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    MrLanla 

    you can try this

    Grade = 

VAR _order=MINX(FILTER(Gradegroup,Gradegroup[Order]>'Table'[order]),Gradegroup[Order])
return maxx(FILTER('Gradegroup',Gradegroup[Order]=_order),Gradegroup[Grade])

    pls see the attachment below

ryan_mayu's avatar
ryan_mayu
Super User
5 years ago

MrLanla 

you can try this

Grade = 

VAR _order=MINX(FILTER(Gradegroup,Gradegroup[Order]>'Table'[order]),Gradegroup[Order])
return maxx(FILTER('Gradegroup',Gradegroup[Order]=_order),Gradegroup[Grade])

pls see the attachment below

MrLanla's avatar
MrLanla
New Member
5 years ago
Grade = VAR _order=MINX(FILTER(Gradegroup,Gradegroup[Order]>'Table1'[Order Quantity]),Gradegroup[Order])
return maxx(FILTER('Gradegroup',Gradegroup[Order]=_order),Gradegroup[Grade])
 
Wow! 😮 this is work! i never use Variable in DAX before.
i will try to understand, thanks for help.