Summarize functions returns date/time from a pure date column

[cbirch]

I'm trying to join two columns together but I keep getting the "No common join columns detected" error. The columns are both named "Month" and have all the same values and should both be type 'date'. But when I look at the elements in the join, something looks off.  MarketPrices[Month] is 'date' type, however when I select it in the summarize function, it gets returned as 'date/time'. (The MarketPrices[Month] column is passed through a few tables before that, but all of them are set to 'date' type, and the original data type from the source query is also just 'date'.) 

Is this causing the issue with the join? If so, how do I force the summarize function to return just the regular date? 

SUMMARIZE(
	FILTER(
        MarketPrices,
        MarketPrices[Date] >= DATE(2022, 3, 1)
    ),
    MarketPrices[Month],
    "Price", SUM(MarketPrices[Product]) / SUM(MarketPrices[Demand])
)

[Ritaf1983 · Accepted solution]

Hi @cbirch 

You can modify the data type of your calculated column from UX :

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly