Forum Discussion

PowerZBI's avatar
PowerZBI
New Member
8 months ago
Solved

Calculated days

I have 2 dates and want to calculate working times between those and I want to calculate working days in a month using it. I have relationship between my date table and main table. Please guide me on...
DAX
  • cengizhanarslan's avatar
    cengizhanarslan
    8 months ago

    Please try the formula below:

     

    Working Days in Month =
CALCULATE (
    COUNTROWS ( 'Date' ),
    WEEKDAY ( 'Date'[Date], 2 ) <= 5
)
  • AnkitKukreja's avatar
    AnkitKukreja
    8 months ago

    Hi! PowerZBI 


    You can use something like this, if I understood your problem. Check putting this in matrix visual

    Days Count =
    VAR WO_Start =
    CALCULATE(
    MIN('Table'[Date1]),
    ALL('Calendar')
    )

    VAR WO_End =
    CALCULATE(
    MAX('Labor Data'[Date2]),
    ALL('Calendar')
    )

    VAR StartDate = INT(WO_Start)
    VAR EndDate = INT(WO_End)

    VAR _days =
    COUNTROWS(
    FILTER(
    'Calendar',
    'Calendar'[CALENDAR_DATE] >= StartDate &&
    'Calendar'[CALENDAR_DATE] <= EndDate &&
    )
    )

    RETURN
    _days

     

     

     

     

     

     

     

AnkitKukreja's avatar
AnkitKukreja
Super User
8 months ago

Hi! PowerZBI 


You can use something like this, if I understood your problem. Check putting this in matrix visual

Days Count =
VAR WO_Start =
CALCULATE(
MIN('Table'[Date1]),
ALL('Calendar')
)

VAR WO_End =
CALCULATE(
MAX('Labor Data'[Date2]),
ALL('Calendar')
)

VAR StartDate = INT(WO_Start)
VAR EndDate = INT(WO_End)

VAR _days =
COUNTROWS(
FILTER(
'Calendar',
'Calendar'[CALENDAR_DATE] >= StartDate &&
'Calendar'[CALENDAR_DATE] <= EndDate &&
)
)

RETURN
_days