Forum Discussion
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 ...
olgad As per your suggestion I tried creating the Date Table seperately and Link between two Data Tables.
1. Created Date Column as per your instructions
2. Created One To Many Relation Ship (But Automatically convert as Many to One)
3. Choosen Cross Filter Direction: Single (Even I tried Both)
Result: Now Its not showing any Month Names.
Create on the Date table the column Month
Month = FORMAT([Date], "MMM")&","&'Date'[Year]and put that column into the visual