Forum Discussion

dbollini's avatar
dbollini
Icon for Helper II rankHelper II
1 year ago
Solved

Power Query to Find Project Names which do not have update in current month

I need to find Project names from Project master table by checking the monthly updates table if the particular project had update for that particular month and if it does not have any updates in mont...
Data Protection
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi dbollini,

    The error likely occurs because "CONTAINSROW" expects a single-column table or explicit values for each column in the comparison. To fix this, you need to correctly filter "MonthlyUpdates" and check if the "ProjectMaster[ID]" exists in it. 
    You can also try use EXCEPT or LOOKUPVALUE in place of IN for better logic. 

    ProjectsWithoutUpdate =
    VAR SelectedMonth = SELECTEDVALUE(MonthlyUpdates[monthstartdate])

    RETURN
    FILTER(
    ProjectMaster,
    ProjectMaster[ProjectStatus] IN {"On-Track", "Delayed", "At-Risk"} &&
    NOT ISBLANK(
    LOOKUPVALUE(
    MonthlyUpdates[projectid],
    MonthlyUpdates[projectid], ProjectMaster[ID],
    MonthlyUpdates[monthstartdate], SelectedMonth
    )
    )
    )

     

    If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

    Best Regards,
    Hammad.
    Community Support Team

     

    If this post helps then please mark it as a solution, so that other members find it more quickly.

    Thank you.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi dbollini,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.

If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.


If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.