Forum Discussion
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. Instead of summing the value of all the transactions per month, I need to list each transaction row by row for the current month.
Keen to do this using a measure which will automatically filter transactions for the current month rather than relying on a slicer to make it simpler for the end user. I've tried using the DATESMTD but can't seem to get it to return the individual transaction details for the current month only.
The output is simple but I'm struggling to get it to list each transaction rather than summing. Output example below:
Transaction value Transaction Month
$80 Sep 20
$90 Sep 20
$100 Sep 20
$60 Sep 20
$110 Sep 20
$120 Sep 20
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
3 Replies
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.
Hi , Marcus_E
If you just want to get the data of current month.Maybe you can try to create relative date range filter .
Best Regards,
Community Support Team _ Eason
