Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Moving from QlikView to Power Bi

Hello,

I am facing a problem when converting the below QlikView expression into Power BI measure,
Please help me to convert this expression to Power BI.

QlikView Expression:

 

SUM(Aggr(Max({ <AchMonth = { $(=MaxString(AchMonth))}> } numCompletion ),varAction ))

 

All these columns are in the same table.
Please help me to get through this issue,

Thank you.

 
 
 
 
General Comment
Interesting Links
Need Help
Tutorial Requests

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

     

    Something I can think of is sumx

    SUMX(Filter(allselected(Table),Table[MonthYear] =max(Table[MonthYear])),Table[Value])

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi  Anonymous  ,

    I’m not very clear about the meaning of this QlikView expression. Can you explain the specific logic?

    So that it is better for me to help you.

     

     

    Best Regards,

    Liu Yang

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