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

     

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