Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
@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
The way you use CROSSJOIN in your example has helped me in solving my problem. Thanks again!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |