Forum Discussion
Using a inactive relationship in selectcolumn dax
Hey I've created a Date Table from multiple different tables createdates that looks like this Date Table = DISTINCT(UNION (SELECTCOLUMNS ( 'Lead', "Date", 'Lead'[CreatedDate] ),SELECTCOLUMNS...
The problem I've found using calendar is are using date times and it's only checking for date time at 12:00 and won't look at the whole day. Also I don't think that resolves my original question.
Hi Nudo
Yes, calendar function returns datetime values with timestamp 12:00 a.m. but you can change the Date column from Date/time data type to Date type to remove timestamps.
Currently you are selecting CreatedDate columns from multiple tables to create a calendar table. What relationships exist between tables? What effect or output result do you want to get through those inactive relationships? Can you provide some mock data to show the expected result you want?
Jing