cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Dates outside dataset range mess up readings

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

1.png 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

2.png3.png

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

thanks in advanced.

2 REPLIES 2
Community Support
Community Support

Re: Dates outside dataset range mess up readings

Hi @MarvinConceição ,

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

 

Best regards,
Lionel Chen

Re: Dates outside dataset range mess up readings

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 )
)

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors