Forum Discussion
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 chart filtered on the last year and the diference between the sameperiodlastyear and the actual was calculated with the right number, but today (may 2024 update) this diferrence (it is a new measure) does not work correctly. Does any one has the same problem?
3 Replies
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.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
- 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))
