Creating table with date column with month and year based on other columns

[Anonymous]

I want to create a fact table in which I show contracts (Contractnummer), which has a valid from (Contract vanaf) and valid to (Contract tot) date with a component (Component) within that contract, which also has a valid from (Prijs vanaf) and valid to (Prijs tot) date, and the amount (Bedrag) that corresponds to the component. This table looks like this:

In this table, I want to create a column which shows all months and years in which both the contract and the component are active. Hence, I am looking for all months and years between the latest date of Contract vanaf and Prijs vanaf and the earliest date of Contract tot en Prijs tot for each contract and component. This should then look like:

I want to have a similar table as above but then using DAX

[amitchandak · Accepted solution]

@Anonymous ,not very clear. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

But I think the attached file after signature or the blog I sharing can help

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785

[Anonymous]

The way you use CROSSJOIN in your example has helped me in solving my problem. Thanks again!