Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Glitch in the Matrix (Informe)

Tengo mi tabla de fechas DAX habitual que siempre uso.... y parece a prueba de balas.... y, sin embargo, de repente soy incapaz de ordenar el visual de Matrix por fecha. ¿Ha cambiado una configuración PowerBI Desktop? ¿O podría haber una falla en el informe de Matrix?

DimDate = 
VAR MINYEAR =   2014  
VAR MAXYEAR =   2025
RETURN
ADDCOLUMNS (
    FILTER (
        CALENDAR(DATE(MINYEAR,1,1),DATE(MAXYEAR,12,31)),
        AND ( YEAR ( [DATE] ) >= MINYEAR, YEAR ( [DATE] ) <= MAXYEAR )
    ),
"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),
"Year", YEAR ( [Date] ),
"Monthnumber", FORMAT ( [Date], "MM" ),
"HalfYear", YEAR([Date])&" H"&ROUNDUP(MONTH([Date])/6,0),
"YearMonthnumber", FORMAT ( [Date], "YYYY/MM" ),
"YearMonthShort", FORMAT ( [Date], "YYYY/mmm" ),
"MonthNameShort", FORMAT ( [Date], "mmm" ),
"MonthNameLong", FORMAT ( [Date], "mmmm" ),
-- as text "DayOfMonth", FORMAT ( [Date], "d" ),
"DayOfMonth", DAY ( [Date]), 
"DayOfWeekNumber", WEEKDAY ( [Date] ),
"DayOfWeek", FORMAT ( [Date], "dddd" ),
"DayOfWeekShort", FORMAT ( [Date], "ddd" ),
"DayNumber", FORMAT ( [Date], "d" ),
"Quarter", FORMAT ( [Date], "Q" ),
"YearQuarter", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" ))

1 Reply