Forum Discussion
Custom Column Homologous Month
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.
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?
Ok, there's a previous month Function and for homologous month?
Your requirement is not quite clear for me, please check if below DAX expressions work.
CurrentMonth = YEAR([date])=YEAR(TODAY()) && MONTH([date])=MONTH(TODAY()) previousMonth = YEAR([date])=YEAR(TODAY())&&MONTH([date])+1=MONTH(TODAY()) HomologousMonth = YEAR([date])+1=YEAR(TODAY())&&MONTH([date])=MONTH(TODAY())
If you have any question, feel free to let me know.
Yes, it works! But those 'New Columns' are not usable in Power Query? Eric_Zhang