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'...
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!!

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!!

  • Andy83's avatar
    Andy83
    Frequent Visitor
    2 years ago

    Thank you