I have two tables, Dates and Contracts:
How can I join them like this?
Go to Solution.
@BlackBird Try Cross Join functionCROSSJOIN(VALUES(TABLE1[DATE]_,VALUES(TABLE2[CONTRACTS))
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
View solution in original post
If you have a Dates and Contracts table as shown, in the Dates table, simply add a custom column in Power Query, then type =Contracts as your formula. It will initially look like this:
You an see the formula above just references the Contracts table. (if your table has a space in it, it would be ...each #"New Contracts")
Then just expand the Contracts column.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
You may create a calculated table as below.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.