Forum Discussion
Last Month Data
Hello I have a very simple issue, Below is the data set, I always need previous month count, like in current month. I need September data. PLease help.
Thanks yes, I have a date table which connects with other data table
Here is my measure = TOTAL_SALES = SUMX(Filter('SALES_TABLE','SALES_TABLE'[COLOR]="Blue"),'SALES_TABLE'([Amt])
Measure 2 = CALCULATE ([TOTAL_SALES], PREVIOUSMONTH('DATE_Table'[Date_Key]))
But as you can see, it returens all the previous months, if I remove Year_Month column, it dows not show any data
Ashish_Mathur
Super User
Super UserHi,
What is the problem with this output? What result are you expecting?
I just want to get one value SUM of Last Month, but it is returning sum of each month like 15 rows or so.
Not entirely clear on what you are looking for, but have you given OPENINGBALANCEMONTH or PARALLELPERIOD try?
AnonymousI'm looking for very simple output only sum of last month's sales.