Forum Discussion

MarcUrdang's avatar
MarcUrdang
Icon for Post Patron rankPost Patron
6 years ago
Solved

Date filtering

I use this calc to filter a count of a categor (Shipment ID) using a date field to filter (Dest ETA).  This shows me the data required based on last month (monthtToday()=November) so therefore Octobe...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi MarcUrdang 

    Yes, you could just change the -1 to -2 for your requirement.

    Calc =
    CALCULATE (
    COUNT ( Input[Shipment ID] ),
    FILTER (
    Input,
    Input[Dest ETA]
    >= DATE ( YEAR ( today() ), MONTH ( TODAY() ) - 2, 1 )
    && Input[Dest ETA] < DATE ( YEAR ( TODAY() ), MONTH ( TODAY() ), 1 )
    )
    )
     
    Regards,
    Lin
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

hi MarcUrdang 

Yes, you could just change the -1 to -2 for your requirement.

Calc =
CALCULATE (
COUNT ( Input[Shipment ID] ),
FILTER (
Input,
Input[Dest ETA]
>= DATE ( YEAR ( today() ), MONTH ( TODAY() ) - 2, 1 )
&& Input[Dest ETA] < DATE ( YEAR ( TODAY() ), MONTH ( TODAY() ), 1 )
)
)
 
Regards,
Lin