Joining tables

Question

I have this manually created date tabel with dates from 1.jan 2017 to 1.aug 2020&nbsp;I want to join it with this tableElement typePost&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DiscussionPictureFolder&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Note&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Link&nbsp;in a way that results in&nbsp;DateElement typeCount1.janPost&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01.janDiscussion01.janPicture&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01.janFolder&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01.janNote&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01.janLink02.janPost&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;02.janDiscussion02.janPicture&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;02.janFolder&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;02.janNote&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;02.janLink0and so on....&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Can anyone point me in the right direction?

amitchandak · Accepted Answer

moei , use crossjoin 
refer : https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

Forum Discussion

Joining tables

1 Reply

Related content

Joining 3 Tables (4 with DimDate)

conditional join

Join the community

PowerBI - table join question

Spatial Join

Date	Element type	Count
1.jan	Post	0
1.jan	Discussion	0
1.jan	Picture	0
1.jan	Folder	0
1.jan	Note	0
1.jan	Link	0
2.jan	Post	0
2.jan	Discussion	0
2.jan	Picture	0
2.jan	Folder	0
2.jan	Note	0
2.jan	Link	0
and so on....