This content has been marked as final. Show 3 replies
I am wondering if there is a way to make Month-Year as a free-standing dimension that I can use in timeline charts, where the dates are not connected to a Master Calendar. I have multiple date values in different tables, and only a few are linked. For example:
StartOfCare Date and ReferralDate are in the same table. Conversion Rate is StartOfCare/ReferralDate. Referral dates and start dates can be in different months, especially at the beginning and ending of the month.
I tried to make a month Dimension on an unlinked Master Calendar, but that didn't work .
Any suggestions? Thanks in advance for any feedback!