Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
Hi @djrhenderson ,
Has your problem solved? If solved, please consider Accept it as the solution to help the other members find it more quickly.
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.
@djrhenderson , refer if these two links can help
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
User | Count |
---|---|
57 | |
21 | |
19 | |
16 | |
16 |
User | Count |
---|---|
86 | |
77 | |
52 | |
37 | |
22 |