added table of months (into axis) and i need to connect my data table to those months

[Anonymous]

i used this as a new table

MonthAndYears = DISTINCT(SELECTCOLUMNS(
ADDCOLUMNS(
SELECTCOLUMNS(
CALENDAR(TODAY()-365,TODAY()),"DateAdded",[Date]),"MonName",FORMAT([DateAdded],"mm/1/YYYY")
),"Months",[MonName]))

dropped that into my AXIS

my 2nd table has a date, measure, Patient ID

i want my value created measure to reference the current month on the axis
it currently just loads all the table count into each month

how do i tell my measure from my data table to filter by the axis months (from a different table)?

[MFelix · Accepted solution]

Hi @Anonymous ,

You should create a relationship between both tablesbased on the date columns, be sure that the column you are using on the axis is part of the 1 in the many to 1 relationship between the tables.

Regards,

MFelix