Forum Discussion
DateDiff with Working Days and Sums
I am currently transforming old reports to new PowerBI ones and am stuck on this particular part. I need to do a date difference beween DepositDate and CmplDate, this needs to be for working days onl...
You would want to relate your data table to a Date Dimension. The Date Dimension table will have a row for every date, no gaps. One of the columns in the Date Dimension table would be WorkDay (values Y or No, 0 or 1, etc.) You can then use a CALCULATE function on the measure to FILTER only for WorkDay = 'Y'
I am so sorry i am really new at PowerBI and i dont understand what you mean by a Date Dimension table? Is this something that i will need to do in Power Query? If so, how would i do this?