Forum Discussion

Andy83's avatar
Andy83
Frequent Visitor
2 years ago
Solved

DAX PREVIOUSMONTH()

Hi All, 

 

I have the following Query within Power Automate at the moment. I need the red parts below to be dynamic so it collects the previous months data. 

 

FILTER(
KEEPFILTERS(VALUES('Dates'[Date])),
AND('Dates'[Date] >= DATE(2024, 6, 18), 'Dates'[Date] < DATE(2024, 7, 18))
)

 

I thought something like this might work. I thought about maybe using the MONTH function someone and minus 1. Any help would be much appreciated. Thanks

 

FILTER(
KEEPFILTERS(VALUES('Dates'[Date])),
AND('Dates'[Date] >= DATE(PREVIOUSMONTH()), 'Dates'[Date] < DATE(TODAY()))
)

Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    Hi Andy83 - you can try the below measure for previous month's data without manually updating 

     

    CALCULATE(
    SUM('YourTable'[YourColumn]),
    FILTER(
    KEEPFILTERS(VALUES('Dates'[Date])),
    'Dates'[Date] >= STARTOFMONTH(EOMONTH(TODAY(), -1)) &&
    'Dates'[Date] < STARTOFMONTH(TODAY())
    )
    )

     

     

    Hope it works for you.

     

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!

2 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    2 years ago

    Hi Andy83 - you can try the below measure for previous month's data without manually updating 

     

    CALCULATE(
    SUM('YourTable'[YourColumn]),
    FILTER(
    KEEPFILTERS(VALUES('Dates'[Date])),
    'Dates'[Date] >= STARTOFMONTH(EOMONTH(TODAY(), -1)) &&
    'Dates'[Date] < STARTOFMONTH(TODAY())
    )
    )

     

     

    Hope it works for you.

     

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!