Master calendar not matching with fact table field

[TomBond77]

Hi experts

My master calendar is matching with the field "Date" of my fact table:

But in the App itself it is not matching with the facts, there are two records instead of one record for each "Date":

Does anyone know why? Thanks for any advises.

Tom

[cristianj23a]

They can be several cases.

In any case, use the "Trim" command in the "Date" field, in the script.

For example:

load
Category,
Trim(Date) AS Date,
....

If it does not work for you, it may be another case, for this I would need your test data to review it.

[marcus_sommer · Accepted solution]

Make sure that your date is a date and not a timestamp, for example per:

date(floor(Date)) as Date