Forum Discussion
Comparing Dates from Two tables - Month based date against day based date
Anonymous,
In the BillableHours table, create this calculated column:
Date = DATE ( BillableHours[Year], BillableHours[Month], 1 )
Then, use this column to create a relationship with the calendar table (date column).
Thank you DataInsights! That helped me get on the right track but did not form the relationship I needed.
With that relationship, a visualization that used both tables had issues with aggregates on time entries that were not on the first of the month.
To resolve this issue I was able to format the date column in the 'Monthly Billable Hours' table to be YearMonth [2021-01]. Then on the calendar table I used the simple dax command to add the column for YearMonth to the Autocalendar table generated. This way all time entries of January 2021 were assoicated with the right total of monthly billable hours.
As a note, after posting this question, my company upgraded me from the trial to pro version, and for some reason I needed to recreate my account here, hence the extra _.
Edit: I would like to point out the reason your answer didnt resolve my issue is largely due to the way I posed my question and the lack of information on what I wanted from my visual. I'll try to get the ghost acocunt worked out so this can be marked as the answer. Thank you kindly.
