Forum Discussion

baneworth's avatar
baneworth
Icon for Helper III rankHelper III
4 years ago

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 ...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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)

  • baneworth's avatar
    baneworth
    Icon for Helper III rankHelper III
    4 years ago

    Dear amitchandak 

     

    Thank you for quick reply.

     

    I have 2 Questions

    1. What do you refer to as "vwPassdownNew[Date]"?  I do not have such as of now.

    2. my Work_Day is a column created by SQL Datasource. Therefore i can not change as you recommended. What can i do instead? Or did you mean a new measure?

     

     

    Best regards

    Matthias