Forum Discussion

astotz's avatar
astotz
Frequent Visitor
7 years ago
Solved

Calculating cross-tabulation in unpivoted table

I have a table of the form: [id, program, enrollment_date] where id is the unique ID of a customer, program is 1 of 12 programs that customer has enrolled in, and enrollment_date is the date that the...
Need Help
  • 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.

 

astotz's avatar
astotz
Frequent Visitor
7 years ago

Super helpful to see how this was done. You used some patterns I wasn't aware of. Thanks so much!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    You are welcome.