Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
53 | |
46 | |
19 | |
16 | |
15 |
User | Count |
---|---|
114 | |
44 | |
44 | |
28 | |
22 |