Forum Discussion
previousmonth not working even with date column
I struggeling with one messaure that is giving me blanks as a results. Flow_Website_CellPhone_PREVIOUSMONTH = Mesaure1: Sum(Flow[Events]) CALCULATE( [Mesaure1];PREVIOUSMONTH(Flow[Date]);Flo...
Thanks for sharing.
I tried addmonth function and subtracted a month.
But that did not work.
Any other idea.
Hello everyone,
Just created a table in power bi. with the following colums
date
currentEvent
PreviuousMonth event.
With these colums. It works.
But when I remove the date colum and replace it with yearmonth. IT does NOT work. I get blank.
It seems that it does not reconize yearmonth as a date but as text and PowerBI does not know how to deal with this.