Forum Discussion

rmiquel's avatar
rmiquel
Frequent Visitor
7 years ago
Solved

Measure with date variable that needs calculation row by row

Hi,   I have been trying to figure this one out but I am going in circles, so asking here in case someone can provide some guidance.   I have 2 tables, one with support cases and another with dat...
Need Help
Tips and Tricks
  • TomMartens's avatar
    TomMartens
    7 years ago

    Hey,

     

    you challenge has a name "Events in progress".

     

    What you basically need is a date table that is not related to you case table :-)

     

    Here you will find some guidance for this kind of problem:

    http://sqljason.com/2012/11/classifying-and-solving-events-in.html

     

    If you get stuck, please prepare a pbix file and some sample data (Excel file), upload the files to onedrive or dropbox and share the link.

     

    Regards,

    Tom

TomMartens's avatar
TomMartens
Super User
7 years ago

Hey,

 

you challenge has a name "Events in progress".

 

What you basically need is a date table that is not related to you case table :-)

 

Here you will find some guidance for this kind of problem:

http://sqljason.com/2012/11/classifying-and-solving-events-in.html

 

If you get stuck, please prepare a pbix file and some sample data (Excel file), upload the files to onedrive or dropbox and share the link.

 

Regards,

Tom