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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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