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.
So here is my fact table and date table, date keys in fact are coming from Date table.
Here is Total Sales
TOTAL_SALES = SUMX(Filter('SALES_TABLE','SALES_TABLE'[COLOR]="Blue"),'SALES_TABLE'([Amt])