How to tranfer Values linked to a discrete Date to a daily or monthly Base

[ChrisBa]

Hello,

In a Power BI Desktop Project i want to generate a Ressource Planning Report based on a Table as follows:

• The Value of Ressource Effort sholud be grouped by Name Employee (Name Mítarbeiter), Name Projekt, Date (See Picture of Visualisation Chart below)
• "Ressouce Effort§ is linked to a "Start Date". The Value is valid until the next "Start Date" (Same Project and Same Employee). For Example: 

         Mitarbeiter A | Project A | 0,22 % (Ressource Effort) is valid from 01.09.2022 to 30.11.2022

         Mitarbeiter A | Project A | 2,39 % (Ressource Effort) is valid from 01.12.2022 to 31.03.2023

         And so on as ragarding table below

Question: How To Tranform the Table OR Apply DAX Formulars in Order to Visualize the data correctly? 

Attached there is a Example File with the Table and Chart.

Many Thanks for any Support in Advance!! 

Regards Christoph

[v-janeyg-msft]

Hi, @ChrisBa 

According to your description, I understand your needs and it's simple, but I don’t know what you want to do. There is no relationship between your screenshot and your description, What effect do you want to show in visual?

Best Regards,
Community Support Team _ Janey

[ChrisBa]

Her The Link for the Example Data:

https://1drv.ms/u/s!Atc8C9JQg533hZ4Tm30IR_hwwJdDBQ?e=tzIg6z