Forum Discussion

Elisa112's avatar
Elisa112
Icon for Helper V rankHelper V
2 years ago
Solved

Calculate date difference between different meeting types which are stored in the same column

Hello I am trying to create a table to calculate the difference between different meeting dates per user (i,e days between intro and assess or intro and support, this must be on the first attended m...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    Elisa112 

    if you want to get the first attended meeting, try to change maxx to minx

  • Elisa112's avatar
    Elisa112
    2 years ago

    ryan_mayu I have successfully added the attended meetings, there was a missing bracket and common which was causing the error.

    Thank you and I can now mark your solution as the accepted (and correct) solution

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Elisa112 ,
Here is my test data:

Create a new table called SummaryTable

SummaryTable = 
SUMMARIZECOLUMNS (
    'MeetingTable'[UserID],
    "DaysBetweenIntroAndAssess", DATEDIFF (
        CALCULATE ( MIN ( 'MeetingTable'[Meeting date] ) ),
        CALCULATE (
            MIN ( 'MeetingTable'[Meeting date] ),
            'MeetingTable'[Meeting Type] = "Assess"
                && 'MeetingTable'[Status] = "Attended"
        ),
        DAY
    ),
    "DaysBetweenIntroAndSupport", DATEDIFF (
        CALCULATE ( MIN ( 'MeetingTable'[Meeting date] ) ),
        CALCULATE (
            MIN ( 'MeetingTable'[Meeting date] ),
            'MeetingTable'[Meeting Type] = "Support"
                && 'MeetingTable'[Status] = "Attended"
        ),
        DAY
    )
)

Final output

 

Best regards

Albert He

 

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

  • Elisa112's avatar
    Elisa112
    Icon for Helper V rankHelper V
    2 years ago

    Hi Anonymous 

    Tried this and my summary table is coming back completely blank, any idea why that would be?

    I feel I am missing something so obvious

    thanks in advance

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Elisa112 ,
      You can refer to the pbix file I provided. Regarding why there are blank data, you can go and check your raw data to see if there are inconsistencies with the matching fields, for example, if there are spaces before and after the raw data that would cause a blank summary to appear

      Please check these fields for any discrepancies, especially spaces.

       

      Best regards

      Albert He

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