Question regarding date/time table

Anonymous — Mon, 14 Aug 2023 15:28:32 GMT

Hello,

I am very new to Power BI and I've encounterd a problem related to time/date convertion and relationship. I'm trying to make a calendar-table "dimKalender" for my sales-table "factSalg" with the relationship *:1. When I link the two different in the model view with "date" it appears as a 1:1 relationship. I have formated both date-related data into date/time, both in PowerQuery and in data view.

The "dimKalender" is made with the following DAX-function:

dimKalender =

Calendar

(date (year (min (factSalg[Dato])), 1,1),

date (year (max (factSalg[Dato])),12,31)

)

I went into PowerQuery and removed the "time"-data on the "factSalg" which made the *:1 connection possible.

Does anybody know how I can fix it so that the "time" is possible to keep, while I can sitll make the *:1 connection between the tables?

Re: Question regarding date/time table

Greg_Deckler — Mon, 14 Aug 2023 16:51:12 GMT

Anonymous Leave the original column in place and add a new column that truncates the time off? Then you make the relationship on the non-time data column but you still have the original column that includes the data and time.

topic Re: Question regarding date/time table in DAX Commands and Tips

Question regarding date/time table

Re: Question regarding date/time table