Forum Discussion

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...

Ashish_Mathur
7 years ago
Hi,

This is the result i got.
Ashish_Mathur
7 years ago
Hi,

You may download my PBI file from here.

Hope this helps.

Super User

7 years ago

Hi,

This is the result i got.

Helper II

7 years ago

Hi Ashish_Mathur, could you please post the PBIX file or the solution steps? Thanks

Ashish_Mathur
Super User
7 years ago
Hi,

You may download my PBI file from here.

Hope this helps.
- msingh2019
  Helper II
  7 years ago
  Hi Ashish_Mathur,
  
  Thanks a lot for your help. Your solution works perfectly!
  
  Thanks again!
  - Ashish_Mathur
    Super User
    7 years ago
    You are welcome.
Ashish_Mathur
Super User
7 years ago
Hi,

Sorry for the delay in replying. I am travelling. Please allow me time until Sunday to share my solution.

Related content