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...
Sometimes working with Time Intellgence functions can be frustrating. See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008
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.