Forum Discussion

msingh2019's avatar
msingh2019
Helper II
7 years ago
Solved

Need help with conditional data aggregation

My source data format (after unpivoting) looks like this -  PatientID | Status | Date p234 | Active | 01-Oct-2018 p234 | Discharged | 12-Dec-2018  p234 | Dropped | 15-Feb-2019 p235 | Active | 11...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    This is the result i got.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

msingh2019's avatar
msingh2019
Helper II
7 years ago

Hi Ashish_Mathur,

 

Thanks a lot for your help. Your solution works perfectly!

 

Thanks again!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    You are welcome.