Forum Discussion
Resolver IMatrix with start and end dates on column
I have imported from Dynamics CRM a list of courses and participants (easy)
I now need a Matrix with:
-Participant name on rows (OK, easy)
-Each course date on Columns, but I only have START and END date for the course
Something like the example below...I need a "dynamic" colum to put in the Matrix...
Follow the below link:
https://community.powerbi.com/t5/Desktop/Getting-all-dates-between-2-dates/td-p/60577
It would help you.
4 Replies
- Greg_Deckler
Community Champion
Can you post example data? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
- autodafe
Here's the Example file...( www.pipeline.it/tmp/TESTFF.pbix )
for each course participant I need to create empty column for the remaing 5 days (they have to sign a paper form for each corse day) with all days between start and end dates
hthotaResolver III
Follow the below link:
https://community.powerbi.com/t5/Desktop/Getting-all-dates-between-2-dates/td-p/60577
It would help you.
