Forum Discussion
Helper VUsing values from a Visual filter in a measure
I apologize for the misplaced " in the formula.
Before you create the date column, click on Month, change the data type to text. Same thing goes to year. Then, you create the date column, after that, change the data type of the date column to date.
Post Prodigy
That's because the relationship isn't done right. If you could see the dotted lines in your relationship view, that means the relationship is not active. You cannot have 2 different relationships for the same 2 tables.
What I will do next is concatenante your month number to your year with a specific date in your data table. I would do this in Power Query by adding a new column.
Rest of the World -
Date: "1/" & [Month] & "/" & "[Year]
OR
North America Version -
Date: [Month] & "/1/" & [Year]
Use the formula depending on your date formats. Apply the query, and use the newly created column in for your relationship between data table and date table.
Helper VTried this one
Rest of the World -
Date: "1/" & [Month] & "/" & "[Year]
It shows an error right away so i took the " before the Year away so i could save. Like this
Rest of the World -
Date: "1/" & [Month] & "/" & [Year]
Now i get an error saying. Expression.Error: We cannot apply operator & to types text and number...
- darentengmfs
I apologize for the misplaced " in the formula.
Before you create the date column, click on Month, change the data type to text. Same thing goes to year. Then, you create the date column, after that, change the data type of the date column to date.