Forum Discussion
dcrios
8 years agoFrequent Visitor
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
https://community.powerbi.com/t5/Desktop/Last-date-Previous-Month/m-p/304830
But when I try this formula to get this value, didn't work as well when I put the measure in a Column chart. It must be appear the value from the date 30-11-2017 (9.057.180.489.18). Can anyone please help me with this?
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