Couunt of files till yesterday

[Mani_1]

Hi,

I am trying to count the files till yesterday for the current month so i used the Dax as follows

File Count =

CALCULATE(

    COUNT('001'[File]),

    FILTER('001','001'[Date - Order]<=(TODAY()-1)), FILTER('001','001'[Date - Order]= [Current month]))

But it is not working 

[grazitti_sapna · Accepted solution]

Hi @Mani_1 

You can try using 

File Count =
CALCULATE(COUNT('001'[File]),
'001'[Date - Order] <= TODAY() - 1,
'001'[Date - Order] >= DATE(YEAR(TODAY()), MONTH(TODAY()), 1)
)
Thank you 
Hope this will help you.