Forum Discussion

gonrodrigues's avatar
gonrodrigues
Helper III
10 years ago
Solved

Custom Column Homologous Month

Hello,   To create colum Current Month I used this:   Table.AddColumn(MonthName, "CurrentMonth", each Date.IsInCurrentMonth( [Date] )) and if I want to creat two more: "HomologousMonth" and "Pre...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    gonrodrigues

     

    They're DAX expressions, I was not using Power Query. Is Power Query necessary?

  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    gonrodrigues

     

    You can get the HomologousMonth with Date.IsInCurrentMonth as well.  Just add one year to [Date] and predicate it with IsInCurrentMonth.

    Table.AddColumn(PreviousMonth, "HomologousMonth", each Date.IsInCurrentMonth( Date.AddYears([Date],1) ))



    If you have any question, feel free to let me know.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

Can you explain what you want PreviousMonth to be? Do you want the actual previous month or do you want it to be a TRUE/FALSE value like CurrentMonth. And I have no idea what you are going for with HomologousMonth, is that the same as the current month in a different year? And is that also TRUE/FALSE or something else?

gonrodrigues's avatar
gonrodrigues
Helper III
10 years ago

Hey Greg_Deckler

 

I want both TRUE/FALSE. HomologousMonth would be the same month in previous year :)

 

Thanks