project employee and month new.pbix (148.1 KB)
Magnus
I found a workaround ,
started with reference the dimension table called it " Dimensiontable expanded "
added some additional column using M language (–> check via Edit query to see the M code)
column Dates for projects expands the table for each project with dates between startDate and endDate
a correction column for the WY value on a daily basis
a relationship between the datetable and the " Dimensiontable expanded "
below a screenshot of the " Dimensiontable expanded "
you can delete the start Date and End Date via Edit Query, I left them for checking purpose
the row totals on the second visual are not correct and therefore hidden.
the totals on the first visual are correct but miss a day on the last day of the project ( see december and august )
kind regards
Roger
