Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Calendar table issue when using filter days

Dears: good afternoon, and good year to all, I write to see if someone can give me a help, since I am having a problem after making the relationship between the calendar table and the table that has the data:

I am creating the calendar table as follows:

CALENDAR RESOLVED = ADDCOLUMNS(CALENDAR (MIN(Resolved[Resolved]), .MAX(Resolved[Resolved])),
"NUMBER MY", FORMAT ([Date], "MMMM"),
"MES", MONTH([Date]),
"YEAR", YEAR([Date]),
"DAY", DAY ([Date]),
"YEAR MONTH NUMBER", FORMAT ( [Date], "YYYY/MM" ),
"NUMBER DAY WEEK", WEEKDAY ( [Date],2 ),
"NUMBER WEEK", WEEKNUM([Date],1),
"WEEK DAY", FORMAT ( [Date], "dddd" ),
"QUARTER", "Q" & FORMAT ( [Date], "Q" ),
"QUARTER OF THE YEAR", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" )
)
At the time of making the relationship with the table where the data are, there is no problem, but when I want to make a query of a certain date, it shows me the following:

IN THE FILTER DAYS A BLANK FIELD, WHICH MO EXISTS IN THE DATA TABLE AND THE DAYS I HAVE LOADED WITH DATA, WHEN I WANT TO SEE THE INFORMATION ONLY SHOWS WITH THE FIELD THAT SAYS WHITE AND WITH THE OTHERS DOES NOT SHOW ME ANYTHING.-

That happens with the white filter

This happens when I use a certain date.-

I fixed the measures for the doubts that have some error and are correct, but this today I surpass myself.-

Someone could tell me where I'm doing wrong.-

Sdos.

John Paul