Forum Discussion
Solved
Measure to return current month transactions
Hi Hoping someone can point me in the right direction with a measure I'm struggling with. I have a series of transactions which (for simplicity sake) consist of a value ($) and transaction date. ...
Marcus_E , Based on what I got. You need to have a column like this you date table and filter the current month
Month Type = Switch( True(),
Date([Date]) = eomonth(Today(),-1),"Last Month" , //Last Month
Date([Date])= eomonth(Today(),0),"This Month" , //This Month
[Month Year]
)Sort this column on month year
Marcus_E , Based on what I got. You need to have a column like this you date table and filter the current month
Month Type = Switch( True(),
Date([Date]) = eomonth(Today(),-1),"Last Month" , //Last Month
Date([Date])= eomonth(Today(),0),"This Month" , //This Month
[Month Year]
)
Sort this column on month year
Thank you amitchandak that works as required.