Forum Discussion

kyleldi's avatar
kyleldi
Frequent Visitor
9 years ago
Solved

NETWORKDAYS type function in PowerBI

I have a table (vw_WorkCenterUtilization) and a date column (Work_Date) that I need to calculate the oldest and newest date in the data, and the number of work days within it.  I'm using the FIRSTDAT...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi kyleldi,


    Firstly, create a calendar table in Power BI Desktop following the guide in this blog. Then create a column in the calendar table using the Dax below.

    is work day = SWITCH(WEEKDAY([Date]),1,0,7,0,1)

     

    Secondly, create a measure using the following DAX and create a card visual.

     

    Days= CALCULATE(SUM('Date'[is work day]),
           DATESBETWEEN('Date'[Date], 
                        [OldestDate],
                      [NewestDate]
          ))




     

    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi kyleldi,


Firstly, create a calendar table in Power BI Desktop following the guide in this blog. Then create a column in the calendar table using the Dax below.

is work day = SWITCH(WEEKDAY([Date]),1,0,7,0,1)

 

Secondly, create a measure using the following DAX and create a card visual.

 

Days= CALCULATE(SUM('Date'[is work day]),
           DATESBETWEEN('Date'[Date], 
                        [OldestDate],
                      [NewestDate]
          ))




 

Thanks,
Lydia Zhang

sureshdam18's avatar
sureshdam18
Frequent Visitor
8 years ago

Hi,

 

I want to calculate Network days between Created Date to Till Date, My date filed looks like,

 

How can we Calculate, If i am tring the above Dax calculation it is geving the error. calculation is,

is work day = SWITCH(WEEKDAY([Created Date]),1,0,7,0,1)

NetworkDays = CALCULATE(SUM([is work day]),
           DATESBETWEEN([Created Date].[Date],Sheet1[Created Date],TODAY()
          ))

Open Request = IF(AND('Fusion dashboard report'[Completion Status]="Open",  [Status]="MDM Ops Review - Undelete"),'Fusion dashboard report'[Network days], -1)

 

 While i am using this Calculation it showing the below error.

A circular dependency was detected: Fusion dashboard report[Network days], Fusion dashboard report[Open - FLS / Requestor in Days], Fusion dashboard report[Network days].

please help me on this.

 

 

Thanks in Advance.