Forum Discussion
Create a virtual table with Previous date transaction column
Hi everyone,
I have problem with creating a Virtual table with Previous date transaction column. Has everyone can help me?
The formula to get the Previous date column is below:
But the result is still blank.
Hi ngocrin1
Actually I did not get the idea of using 'Date'[Date] to obtain the previous date. If you want to get pervious calendar date then simply useVirtual Table = ADDCOLUMNS ( SUMMARIZE ( Sales, Sales[Purchase Date], Sales[Sales Person ID] ), "@Revenue", [Sales Revenue], "@PreDate", Sales[Purchase Date] - 1 )If you're looking for the previous sales date of the product in row then please try
Virtual Table = ADDCOLUMNS ( SUMMARIZE ( Sales, Sales[Purchase Date], Sales[Sales Person ID] ), "@Revenue", [Sales Revenue], "@PreDate", VAR CurrentDate = Sales[Purchase Date] VAR PreDate = MAXX ( CALCULATETABLE ( VALUES ( Sales[Purchase Date] ), Sales[Purchase Date] < CurrentDate ), Sales[Purchase Date] ) RETURN PreDate )
3 Replies
- tamerj1Community Champion
Hi ngocrin1
Actually I did not get the idea of using 'Date'[Date] to obtain the previous date. If you want to get pervious calendar date then simply useVirtual Table = ADDCOLUMNS ( SUMMARIZE ( Sales, Sales[Purchase Date], Sales[Sales Person ID] ), "@Revenue", [Sales Revenue], "@PreDate", Sales[Purchase Date] - 1 )If you're looking for the previous sales date of the product in row then please try
Virtual Table = ADDCOLUMNS ( SUMMARIZE ( Sales, Sales[Purchase Date], Sales[Sales Person ID] ), "@Revenue", [Sales Revenue], "@PreDate", VAR CurrentDate = Sales[Purchase Date] VAR PreDate = MAXX ( CALCULATETABLE ( VALUES ( Sales[Purchase Date] ), Sales[Purchase Date] < CurrentDate ), Sales[Purchase Date] ) RETURN PreDate )- ngocrin1Frequent Visitor
Tks Tamerj1,
It worked well. I'm looking for previous date sales transactions.