Forum Discussion

dcrios's avatar
dcrios
Frequent Visitor
8 years ago
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

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?

 

 

 

  • dcrios's avatar
    dcrios
    8 years ago

    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

9 Replies

  • rocky09's avatar
    rocky09
    Solution Sage

    did you have any page leve/report level filters applied?

    • dcrios's avatar
      dcrios
      Frequent Visitor

      No, it doesn't. I just created in a new Dashboard to test this formula