Forum Discussion

TechMG's avatar
TechMG
Frequent Visitor
2 years ago

Convert SQL to DAX

Hi, I have a paginated report which access the source as Power BI data model, both are deployed in service. I have set of parameters exist in Paginated Report. For ex. ProgramName. It contains list o...
"Need Help"
SQL to DAX
TechMG's avatar
TechMG
Frequent Visitor
2 years ago

Hi Anonymous 

 

Thanks for your quick response. I have executed the query and getting below error.

Query (13, 5) Too few arguments were passed to the LOOKUPVALUE function. The minimum argument count for the function is 3.

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi TechMG ,

 

I'm sorry I changed my dax.

Table = FILTER(ADDCOLUMNS(SELECTCOLUMNS('P',"ProgramId",[ProgramId],"ProgramName",[ProgramName]),"InternalEmailAddress",LOOKUPVALUE(
        'dimuser'[InternalEmailAddress],
        'dimuser'[UserId],
        'userclinicbridge'[ClinicId]
    )),[InternalEmailAddress]=userprincipalname())

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

  • TechMG's avatar
    TechMG
    Frequent Visitor
    2 years ago

    Hi Anonymous ,

     

    Tried the above solution and it is saying Incorrect syntex Table.