Forum Discussion

ohb60's avatar
ohb60
Frequent Visitor
7 years ago
Solved

Previous month name in a empty table

Hi PBI expert,

 

I'm a beginner and I'm using Json file with relative date (month -1) and I'd like to find the name of the previous month from today's date...

 

So this is how I find the actual month...and it display "mars" (maybe not the best method...)
But what I want is to display "february" ...how can I do that ? 

= let
Source = Table.FromRows({{Date.MonthName(DateTime.LocalNow())}},{"Month"})
in
Source
Need Help
  • ohb60's avatar
    ohb60
    7 years ago

    Finally I found something that works : 

     

    PrevMon = FORMAT(EDATE(NOW();-1);"MMMM")

    :smileyhappy:

     

    Thanks everyone !

7 Replies

    • ohb60's avatar
      ohb60
      Frequent Visitor
      7 years ago

      Both method interest me but maybe I should say : the most simple one :)

      • PattemManohar's avatar
        PattemManohar
        Icon for Community Champion rankCommunity Champion
        7 years ago

        ohb60  Please try this to get the previous month name 

        Power Query Editor (M-Code)

        = Table.AddColumn(#"Added Custom", "PrevMonth", each Date.MonthName(Date.AddMonths([hiredate],-1)))

        DAX

        PrevMon = FORMAT(EDATE(emp[hiredate],-1),"MMMM")

         

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Try this:

     

    Measure 2 = 
VAR __currentMonth = MONTH(EOMONTH(TODAY(),0))
VAR __previousMonth = IF(__currentMonth = 1,12,__currentMonth - 1)
VAR __previousYear = IF(__currentMonth = 1,YEAR(TODAY()) - 1,YEAR(TODAY()))
RETURN
FORMAT(DATE(__previousYear,__previousMonth,1),"mmm")
    • ohb60's avatar
      ohb60
      Frequent Visitor
      7 years ago
      Greg_Deckler wrote:

      Try this:

       

      Measure 2 = 
VAR __currentMonth = MONTH(EOMONTH(TODAY(),0))
VAR __previousMonth = IF(__currentMonth = 1,12,__currentMonth - 1)
VAR __previousYear = IF(__currentMonth = 1,YEAR(TODAY()) - 1,YEAR(TODAY()))
RETURN
FORMAT(DATE(__previousYear,__previousMonth,1),"mmm")


      Thank you Greg but it's not working for me...I have this error when I try to validate this new measure :

       

      La syntaxe pour '.0' est incorrecte. (DAX(VAR __currentMonth = MONTH(EOMONTH(TODAY().0))VAR __previousMonth = IF(__currentMonth = 1.12,__currentMonth - 1)VAR __previousYear = IF(__currentMonth = 1.YEAR(TODAY()) - 1.YEAR(TODAY()))RETURNFORMAT(DATE(__previousYear,__previousMonth.1),"mmm"))).