Forum Discussion

bigk's avatar
bigk
Icon for Helper III rankHelper III
2 years ago
Solved

Calculated measure based on date from related table

Hello folks   I’ve run into problems with calculated measures. I have 3 tables with meeting dates, projects and tasks. The relationship is one-to-many in the following path - Meeting dates->Projec...
Need Help
  • bigk's avatar
    bigk
    2 years ago

    I ended up redesigning my query and tables so this is not valid anymore.

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
2 years ago

Hi bigk - Ok, i was checking on that only, can you try below one.

 

Completed Tasks =
VAR CurrentMeetingDate = SELECTEDVALUE('Meeting Dates'[Meeting Date])
VAR PreviousMeetingDate =
CALCULATE(
MAX('Meeting Dates'[Meeting Date]),
FILTER(
ALL('Meeting Dates'),
'Meeting Dates'[Meeting Date] < CurrentMeetingDate
)
)
VAR TasksBetweenDates =
CALCULATETABLE(
'Tasks',
'Tasks'[Completion Date] > PreviousMeetingDate &&
'Tasks'[Completion Date] <= CurrentMeetingDate
)
RETURN
COUNTROWS(TasksBetweenDates)

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

bigk's avatar
bigk
Icon for Helper III rankHelper III
2 years ago

Still same results. 

Maybe there is some way to share my pbix to you or it won't help?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi bigk 

     

    Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

     

    Best Regards

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