Forum Discussion
Solved
Previous Month with problems
Hello everybody, I faced many times people trying to bring values from the previous month. But in my case, I was trying to bring de last date from previous month, like the formula in this link h...
Oh ty Ashish_Mathur I already did what I need. I created a filter to the current and the previous month and putted on the sheet. So in the measure, I created a DAX calculation with calculate(sum(measure), lastdate(date)) and it worked fine for me. But thanks for replying this question. Have a great day
No, it doesn't. I just created in a new Dashboard to test this formula
can you post sample data
vlr_liquido Data Foto 9057236024 12/1/2017 9057222095 11/29/2017 9057180489 11/30/2017 is this what you are trying?
No. I tried to explain that I want to show the last date from previous month, like in the formula I posted in the first post. So if I got 01-12-2017 as my current date in the database and all dates from november, I want to show the value of 30 nov 2017 because Its the last date from previous month.