Forum Discussion

davidibarrag's avatar
davidibarrag
Helper I
2 years ago
Solved

Problem with Matrix Actual and Last Month

Does anyone is having problems with the matrix in Power BI visualizations when trying to compare actuals vs past months in May 2024 update? I have a reports in previous updates and the same matrix wo...
Need Help
Show and Tell
Tips and Tricks
  • sroy_16's avatar
    sroy_16
    2 years ago

    If the DATEADD function is not working try using this DAX and see if it works.

    Sales Q Last Month =
    CALCULATE(
    [Sales Q],
    PARALLELPERIOD(
    'Date'[Date],
    -1,
    MONTH
    )
    )

    Also you can check using "SAMEPERIODLASTYEAR" function. Additionally check if the date table is marked as a date table.
    Let me know if this works.

sroy_16's avatar
sroy_16
Resolver II
2 years ago

If the DATEADD function is not working try using this DAX and see if it works.

Sales Q Last Month =
CALCULATE(
[Sales Q],
PARALLELPERIOD(
'Date'[Date],
-1,
MONTH
)
)

Also you can check using "SAMEPERIODLASTYEAR" function. Additionally check if the date table is marked as a date table.
Let me know if this works.