Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

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

2 Replies