Forum Discussion

Beast's avatar
Beast
Frequent Visitor
3 years ago

Relationship between Two Tables using Date Column

Hello, I tried to Create a Relationship using Date Column from A Table to B Table and but I am getting below result, where B Table Count is repeated for each Month. Note: Month Column is from Table ...
Need Help
olgad's avatar
olgad
Resident Rockstar
3 years ago

Create on the Date table the column Month

Month = FORMAT([Date], "MMM")&","&'Date'[Year]and put that column into the visual
Beast's avatar
Beast
Frequent Visitor
3 years ago

olgad Yes I did the same, Not working. Not sure what is the issue. Attached all the screen shots.

Date Table Forumula: Calendar = CALENDAR(DATE(2022,1,1),DATE(2023,12,31))

Month Column Formula = Month = FORMAT([Date], "MMM" &","& 'Calendar'[Date].[Year])