Forum Discussion

JagThripp's avatar
JagThripp
Frequent Visitor
8 years ago
Solved

Measure\Column calculations not correct

This is my second posting related to getting a aged report for duration of open tickets.   I managed to get something sort of working by advise from this forum, but alas there appears to be errors ...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi JagThripp,

     

    Maybe you can try to use below formula.

     

    Sample formula of calculate column:

    Available workdays =
VAR workdayList =
    FILTER (
        CALENDAR ( Table[Created], Table[Updated] ),
        WEEKDAY ( [Date], 2 ) <= 5
    ) //remove weekend
VAR holidayList =
    VALUES ( Holiday[date] ) //holiday list
VAR remain =
    EXCEPT ( workdayList, holidayList ) //workday except holiday
RETURN
    COUNTROWS ( remain )

     

    If above not help, can you please share some sample data and holiday table? I will try to coding formula on it.

     

    Regards,

    Xiaoxin Sheng