Forum Discussion
Calculate positive and Negative WorkingDays
Hello All, I am new to PowerBI and DAX, So i really need some expereinced suggestions from you all. I have create Calender Table using Calender Function from Calender = CALENDAR(DATE(2018,1,1...
amitchandak there is no sample data or sensitive data for this.
i directly created this calender table and i am trying to create a column which can give me the result as i showed in my question.
amitchandak
Super User
Super UserI create two column. You can merge those.
https://www.dropbox.com/s/bs6m71k27gc76vc/datediff.pbix?dl=0
Also need of a new column for start of month can aslo we removed.
Date diff start of Month = if('Date'[Week day] <6,COUNTx(FILTER('Date','Date'[Week day] <6 && 'Date'[Start of Month]= EARLIER('Date'[Start of Month]) && 'Date'[Date]<= EARLIER('Date'[Date])),'Date'[Date]),0)
Date diff End of Month = -1*if('Date'[Week day] <6,COUNTx(FILTER('Date','Date'[Week day] <6 && 'Date'[Start of Month]= EARLIER('Date'[Start of Month]) && 'Date'[Date]>= EARLIER('Date'[Date])),'Date'[Date]),0)
Hope this will help.