Forum Discussion

cottrera's avatar
cottrera
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Datesbetween not working

Hi    I have two tables a repairs spend table and a dates table I would like to working out the spend between two dates. I have already summed the spend using Dax this measure is called 'Spend' how...
Need Help
  • HotChilli's avatar
    HotChilli
    6 years ago

    I think date format should be

    DATE(<year>, <month>, <day>)

    Is there an error from your formula?

  • Tahreem24's avatar
    Tahreem24
    6 years ago

    cottrera ,

    Your formula seems right except for the DATE format.

    April jobs = CALCULATE([Spend], DATESBETWEEN( 'SHARED Calendar'[PKDate],
    DATE(2020,04 ,06), DATE(2020 , 05 , 02)))
     
     
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
6 years ago

I think date format should be

DATE(<year>, <month>, <day>)

Is there an error from your formula?