X axis with minute value dateadd not working.

[Anonymous]

So I have this table:

And I created the following measure:

Máx Last Day = CALCULATE(

MAX('bravo claro_nrt_view'[activeUsers]),

DATEADD(dCalendar[Date],-1,DAY)

)

This is the result:

I would like to see for instance 08/04/20 00:00 127 and 126 (valeu from 07/04/20 00:00

But if the values are with date and time the comparison is not working,,,,

only in the secont example we can see that its working (when using dates and note date/time).

This is a direct query as the data is being uploaded every 15 min.

Any tips?

[Greg_Deckler]

Post sample data please. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

HI Greg,

Please note that it was supposed to be a direct query..... I imported the data to upload it here.

Kind Regards,

[Anonymous]

If you use a time-intel function, it's working on the data type you supply. If it's datetime, it'll work using datetimes (points in time) and hence it will move the point in time to another point in time, not to a whole day.

The best practice says not to store dates and times together. Make them separate dimensions.

You can use a mixed model (Dual mode) and store the Calendar in the model directly.

Best
D