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
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.