Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to show Network days between using condition

Hi Community,

 

I want to show the network days between Start and End Dates (If they both are in Same Fiscal year) and at the same time if they both are not in same fiscal year i need to show network days between End date's start of fiscal year to end date.

For that i created measure like this.. But in this it will show start and end daysworking days

 

NetworkDays = 

VAR Calendar1 = CALENDAR(MIN('Query1'[Start]),MAX('Query1'[End])) VAR Calendar2 = ADDCOLUMNS(Calendar1,"WeekDay",WEEKDAY([Date],2)) RETURN COUNTX(FILTER(Calendar2,[WeekDay]<=5),[Date]) - COUNTX(FILTER(Calendar2,[WeekDay]>=6),[Date])
 
My other Column name for End date's start of fiscal year is FyStartDay
 
Can you guys Please help out from this
 
Thank you in Advance
 
B V S Sudhakar
 
 
General Comment
Need Help
Show and Tell
Tips and Tricks

1 Reply

  • v-xicai's avatar
    v-xicai
    Community Support
    7 years ago

    Hi Anonymous ,

     

    You can try to create column Datediff like DAX below.

     

    Datediff = DATEDIFF('Query1'[Start],'Query1'[End],DAY)

     

    Or could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

     

    Please read this post to get your answer quickly: How to Get Your Question Answered Quickly.

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.