List Tasks with each day they occur

[djrhenderson]

Hi Folk

I've created a pivot table (using powerpivot) and DAX and while this works, it only lists out the task on day 1 of the scheduled task. the formula I'm using is as follows. 

=CONCATENATEX(TOPN(1,Programme,COUNTA(Programme[Start Date])),Programme[Course Name]," | ")&""

This returns the name of the course linked to the start date as shown here

What I want to see is the task [course name] appear on each day between the start and end date. So for example if the task had a start date of 8/9/22 and end date 11/9/22 I would expect to see the taks name appear on against the 8,9,10 & 11 September

[v-yadongf-msft]

Hi @djrhenderson ,

Has your problem solved? If solved, please consider Accept it as the solution to help the other members find it more quickly.

[v-yadongf-msft · Accepted solution]

Hi @djrhenderson ,

The table I created as below:

Please try following DAX:

Column = MAXX(
    FILTER('course',
    'course'[startdate] <= EARLIER('Table'[Date])&&
    'course'[endtate] >= EARLIER('Table'[Date])),
    'course'[coursename])

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@djrhenderson , refer if these two links can help

https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.