Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
canddig
Frequent Visitor

My Date Calculation is showing blank all of a sudden

Hello, 

 

Can anyone help me trouble shoot why my dax formula would suddenly calculate (blank)? It has never done this to me before. 

 

WorkingDay = VAR UsedDate = Today() -2
VAR FirstDayOfMonth =
DATE( YEAR( UsedDate ), MONTH( UsedDate ), 1 )
VAR WorkDays =
COUNTROWS(
FILTER(
ADDCOLUMNS(
CALENDAR(
FirstDayOfMonth,
UsedDate
),
"WeekDayNumber", WEEKDAY(
[Date],
2
)
),
[WeekDayNumber] < 6
)
)

RETURN
WorkDays
2 REPLIES 2
daxer-almighty
Solution Sage
Solution Sage

Very simple if you run this code in DAX Studio:

 

 

EVALUATE
VAR UsedDate = TODAY() - 2 // today must be 2021-05-03
VAR FirstDayOfMonth =
    DATE( YEAR( UsedDate ), MONTH( UsedDate ), 1 )
VAR WorkDays =
    ADDCOLUMNS(
        CALENDAR(
            FirstDayOfMonth,
            UsedDate
        ),
        "WeekDayNumber",
            WEEKDAY(
                [Date],
                2
            )
    )
    -- [WeekDayNumber] < 6
RETURN
    WorkDays

 

Thanks! I am still getting an error and I am not sure why? I am seeing it as infinity in calculations or (blank)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors