Forum Discussion
Last month
astridaku You can accomplish this by adding a calculated column to your table. Use the following dax calc and set your outputs to identify the current month.
IsCurrentMonth = IF(MONTH(test[Date])=Month(NOW()), "Current Month", "Other")
or rather than text I usually just use bits 1,0 if I'm just filtering on the back end (not in slicers)
IsCurrentMonth = IF(MONTH(test[Date])=Month(NOW()), 1, 0)
Then in your page/report/visual you can filter to only show current, or use a slicer
astridaku You can accomplish this by adding a calculated column to your table. Use the following dax calc and set your outputs to identify the current month.
IsCurrentMonth = IF(MONTH(test[Date])=Month(NOW()), "Current Month", "Other")
or rather than text I usually just use bits 1,0 if I'm just filtering on the back end (not in slicers)
IsCurrentMonth = IF(MONTH(test[Date])=Month(NOW()), 1, 0)
Then in your page/report/visual you can filter to only show current, or use a slicer
Anonymous astridaku correct me if I am wrong ( I write without testing ) but if you have more than 2 years it will display "current month" for 2 months value.
Could it be like
IsCurrentMonth =
IF (
AND (
YEAR ( test[Date] ) = YEAR ( NOW () ),
MONTH ( test[Date] ) = MONTH ( NOW () )
),
"Current Month",
"Other"
)
konstantinos yep - spot on. Your calc will handle multiple years.
Or, in Power Query:
// Power Query // Add custom column CurrentMonthFlag = Date.IsInCurrentMonth( [Date] )
the Power Query custom column is much easier !
