Forum Discussion
Weekday filtering in DAX
Dear All, after checking the forum for hours i give up, i couldn't find the solution to my problem. If anyone could be so kind and take a look at my problem. I have a Column with dates when ...
baneworth , Try like
measure
RFTavg = calculate(AVERAGEX(VALUES(vwPassdownNew[Date]),[RFT]), filter(vwPassdownNew,vwPassdownNew [Work_Day] =1))
where column
Work_Day = if(WEEKNUM([Date],2)>=6,0,1)