Multiple Date Tables

[kdrees21]

I have data where we track expense by project. What I am trying to accomplish is having the project date in the rows and show the dates of expense in the columns. 

Any thoughts on how to do this? 

I am trying to use 2 date tables but I can't get the data to line up.

Any Help is appreciated.

Example:

Project A is completed in 2020 but had expense related to the project from 2019-2021. 

Project B is estimated to be completed in 2021 but has had expense in 2020. 

I would like to show something like this in Power BI: 

[Ashish_Mathur]

Hi,

How is your source data arranged?

[kdrees21]

This is how my model looks and relationships currently flow. 

Is this what you're asking for?

This link will take you to the example .pbix file: https://drive.google.com/drive/folders/19q2p_u58I79rDsdR59-P7AvF4Pysb03c?usp=sharing

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.