Dates outside dataset range mess up readings

[MarvinConceição]

Hi, We are having a problem with the dates on power bi

 We got this dataset with info from 17.01 to 30.01 (you can see total vited being 21)

When we choose a date outside this range the data gets reduced, even still being having that same range within the search

choosing from 17.01 to 31.01 instead of 17.01 to 30.01

or 01.01 to 30.01 the total visited goes down to 15

Can u help me figure out what may be the cause of this?

thanks in advanced.

[v-lionel-msft]

Hi @MarvinConceição ,

Could you show me a data sample model and the DAX formula?

Best regards,
Lionel Chen

[MarvinConceição]

Hi @v-lionel-msft, I was having a trouble with may date table on the relationship with another 2 tables, and i wasn't choosing the date for today.

Still if i chose a superior date that what is on the data set, the data reduces, and I can't figure why, but its working kind of fine now, thanks!

This was my old Dax:

Dates =

VAR BaseCalendar =

CALENDARAUTO(12)

Return

GENERATE(

BaseCalendar,

VAR BaseDate = [Date]

VAR YearDate = Year (BaseDate)

VAR MonthNumber = Month (BaseDate)

Return ROW(

"Day", BaseDate,

"Year", YearDate,

"Month Number", MonthNumber,

"Month", FORMAT(BaseDate, "MMMM"),

"Year Month", FORMAT(BaseDate, "MMM YY")

)

)

And This is how i is now:

NEWDate =

VAR MinDate = DATE ( 2020, 1, 1 )

VAR MaxDate = TODAY ()

RETURN

ADDCOLUMNS (

CALENDAR ( MinDate, MaxDate ),

"Year", YEAR ( [Date] ),

"Quarter Number", INT ( FORMAT ( [Date], "q" ) ),

"Quater", "Q" & INT ( FORMAT ( [Date], "q" ) ),

"Quarter Year", INT ( FORMAT ( [Date], "q" ) ) & "Q"

& RIGHT ( YEAR ( [Date] ), 2 ),

"Month End", EOMONTH ( [Date], 0 )

)