Forum Discussion

davidibarrag's avatar
davidibarrag
Helper I
2 years ago

Measures in visuals does not work

I have creeated a sameperiodlastyear measure and when I place it in my matrix, it does not work correctly even though I place the date in different ways. Other thing I used to do is to create a bar c...
Need Help
Anand24's avatar
Anand24
Super User
2 years ago

Hi davidibarrag ,
Please provide sample data and expected output. Also, please let us know what error/incorrect value you are getting.
This can help us solve your query.

davidibarrag's avatar
davidibarrag
Helper I
2 years ago

Look at the pictures, I create a matriz with monthly sales and sales last year. The first picture is without any filter in the year slicer, and in january 2024 it has the sales of december 2023. But when I filter the year for only 2024, in january the sales from last month disappear. I have antoher power bi file (from april 2024 update) and this mistake does not happen. Do you know what is happening here. Image 1Image 2

  • davidibarrag's avatar
    davidibarrag
    Helper I
    2 years ago
    This is the DAX formula to calculate sales Q Last Month

    Sales Q Last Month =
    CALCULATE(
        [Venta Total Q],
        DATEADD(
            Fecha[Inicio del mes],
            -1,
            MONTH
        )
    )