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,

This is the result i got.

msingh2019's avatar
msingh2019
Helper II
7 years ago

Thanks Ashish_Mathur! This is the correct result. Please do share the PBIX file.