Spreadsheet: 585016d1533570945-previous-from-column-to-the-left-dax-sample-for-last-12-months
Sheet: TABLE 1- DATA

CUSTOMER NUMBER | CUSTOMER NAME | INVOICE NUMBER | INVOICE DATE | ITEM NUMBER | [NAME] | QTY | PRICE | AMOUNT
A112 | [NAME] | 1234 | 2018-08-01 00:00:00 | 9999 | APPLES | 1 | 12
A112 | [NAME] | 1234 | 2018-08-01 00:00:00 | 9999 | APPLES | 1 | 12
A112 | [NAME] | 1234 | 2018-08-01 00:00:00 | 9999 | APPLES | 1 | 12
A112 | [NAME] | 5678 | 2018-07-01 00:00:00 | 9999 | APPLES | 1 | 12
A112 | [NAME] | 5678 | 2018-07-01 00:00:00 | 8888 | ORANGES | 2 | 15
A112 | [NAME] | 5678 | 2018-07-01 00:00:00 | 8888 | ORANGES | 2 | 15
A112 | [NAME] | 5678 | 2018-07-01 00:00:00 | 8888 | ORANGES | 2 | 15
A113 | BOB'S | 3456 | 2018-06-01 00:00:00 | 9999 | APPLES | 1 | 12
A113 | BOB'S | 3456 | 2018-06-01 00:00:00 | 9999 | APPLES | 1 | 12
A113 | BOB'S | 3456 | 2018-06-01 00:00:00 | 9999 | APPLES | 1 | 12
A113 | BOB'S | 5478 | 2018-05-01 00:00:00 | 9999 | APPLES | 1 | 12
A113 | BOB'S | 5478 | 2018-05-01 00:00:00 | 9999 | APPLES | 1 | 12
A113 | BOB'S | 5478 | 2018-05-01 00:00:00 | 9999 | APPLES | 1 | 12
A113 | BOB'S | 1111 | 2018-04-01 00:00:00 | 9999 | APPLES | 1 | 12
A113 | BOB'S | 1111 | 2018-04-01 00:00:00 | 9999 | APPLES | 1 | 12
A113 | BOB'S | 1111 | 2018-04-01 00:00:00 | 9999 | APPLES | 1 | 12
A113 | BOB'S | 4567 | 2018-03-01 00:00:00 | 9999 | APPLES | 1 | 12
A113 | BOB'S | 4567 | 2018-03-01 00:00:00 | 9999 | APPLES | 1 | 12
A113 | BOB'S | 4567 | 2018-03-01 00:00:00 | 9999 | APPLES | 1 | 12
A113 | BOB'S | 987 | 2018-02-01 00:00:00 | 8888 | ORANGES | 2 | 15
A113 | BOB'S | 987 | 2018-02-01 00:00:00 | 8888 | ORANGES | 2 | 15
A113 | BOB'S | 987 | 2018-02-01 00:00:00 | 8888 | ORANGES | 2 | 15
A113 | BOB'S | 56784 | 2018-01-01 00:00:00 | 8888 | ORANGES | 2 | 15
A114 | [NAME]'S | 56784 | 2018-01-01 00:00:00 | 9999 | APPLES | 1 | 12
A114 | [NAME]'S | 56784 | 2018-01-01 00:00:00 | 9999 | APPLES | 1 | 12
A114 | [NAME]'S | 1256 | 2017-12-01 00:00:00 | 9999 | APPLES | 1 | 12
A114 | [NAME]'S | 1256 | 2017-12-01 00:00:00 | 9999 | APPLES | 1 | 12
A114 | [NAME]'S | 1256 | 2017-12-01 00:00:00 | 8888 | ORANGES | 2 | 15
A114 | [NAME]'S | 2789 | 2017-11-01 00:00:00 | 8888 | ORANGES | 2 | 15
A114 | [NAME]'S | 2789 | 2017-11-01 00:00:00 | 8888 | ORANGES | 2 | 15
A114 | [NAME]'S | 2789 | 2017-11-01 00:00:00 | 9999 | APPLES | 1 | 12
A114 | [NAME]'S | 5329 | 2017-10-01 00:00:00 | 9999 | APPLES | 1 | 12
A114 | [NAME]'S | 5329 | 2017-10-01 00:00:00 | 9999 | APPLES | 1 | 12
A114 | [NAME]'S | 5329 | 2017-10-01 00:00:00 | 9999 | APPLES | 1 | 12
A114 | [NAME]'S | 54444 | 2017-09-01 00:00:00 | 9999 | APPLES | 1 | 12
A114 | [NAME]'S | 54444 | 2017-09-01 00:00:00 | 9999 | APPLES | 1 | 12
A114 | [NAME]'S | 54444 | 2017-09-01 00:00:00 | 9999 | APPLES | 1 | 12
A114 | [NAME]'S | 54447 | 2017-08-01 00:00:00 | 9999 | APPLES | 1 | 12
A114 | [NAME]'S | 54447 | 2017-08-01 00:00:00 | 9999 | APPLES | 1 | 12
A114 | [NAME]'S | 54447 | 2017-08-01 00:00:00 | 9999 | APPLES | 1 | 12
A114 | [NAME]'S | 345677 | 2017-07-01 00:00:00 | 9999 | APPLES | 1 | 12
A114 | [NAME]'S | 345677 | 2017-07-01 00:00:00 | 9999 | APPLES | 1 | 12
A114 | [NAME]'S | 345677 | 2017-07-01 00:00:00 | 8888 | ORANGES | 2 | 15
A114 | [NAME]'S | 127899 | 2017-06-01 00:00:00 | 8888 | ORANGES | 2 | 15
A114 | [NAME]'S | 127899 | 2017-06-01 00:00:00 | 8888 | ORANGES | 2 | 15
A114 | [NAME]'S | 127899 | 2017-06-01 00:00:00 | 8888 | ORANGES | 2 | 15
A114 | [NAME]'S | 254441 | 2017-05-01 00:00:00 | 9999 | APPLES | 1 | 12
A114 | [NAME]'S | 254441 | 2017-05-01 00:00:00 | 9999 | APPLES | 1 | 12
A114 | [NAME]'S | 254441 | 2017-05-01 00:00:00 | 9999 | APPLES | 1 | 12
A114 | [NAME]'S | 34566 | 2017-04-01 00:00:00 | 9999 | APPLES | 1 | 12
A114 | [NAME]'S | 34566 | 2017-04-01 00:00:00 | 8888 | ORANGES | 2 | 15
A114 | [NAME]'S | 34566 | 2017-04-01 00:00:00 | 8888 | ORANGES | 2 | 15
A114 | [NAME]'S | 109876 | 2017-03-01 00:00:00 | 8888 | ORANGES | 2 | 15
A115 | ABC STORE | 109876 | 2017-03-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 109876 | 2017-03-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 25417 | 2017-02-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 25417 | 2017-02-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 25417 | 2017-02-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 654788 | 2017-01-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 654788 | 2017-01-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 654788 | 2017-01-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 654711 | 2016-12-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 654711 | 2016-12-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 654711 | 2016-12-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 6987444 | 2016-11-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 6987444 | 2016-11-01 00:00:00 | 8888 | ORANGES | 2 | 15
A115 | ABC STORE | 6987444 | 2016-11-01 00:00:00 | 8888 | ORANGES | 2 | 15
A115 | ABC STORE | 6984211 | 2016-10-01 00:00:00 | 8888 | ORANGES | 2 | 15
A115 | ABC STORE | 6984211 | 2016-10-01 00:00:00 | 8888 | ORANGES | 2 | 15
A115 | ABC STORE | 6984211 | 2016-10-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 21458 | 2016-09-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 21458 | 2016-09-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 21458 | 2016-09-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 666666 | 2016-08-01 00:00:00 | 8888 | ORANGES | 2 | 15
A115 | ABC STORE | 666666 | 2016-08-01 00:00:00 | 8888 | ORANGES | 2 | 15
A115 | ABC STORE | 666666 | 2016-08-01 00:00:00 | 8888 | ORANGES | 2 | 15
A115 | ABC STORE | 2222225 | 2016-07-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 2222225 | 2016-07-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 2222225 | 2016-07-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 128760 | 2016-06-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 128760 | 2016-06-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 128760 | 2016-06-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 2541874 | 2016-05-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 2541874 | 2016-05-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 2541874 | 2016-05-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 347890 | 2016-04-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 347890 | 2016-04-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 347890 | 2016-04-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 3654788 | 2016-03-01 00:00:00 | 8888 | ORANGES | 2 | 15
A115 | ABC STORE | 3654788 | 2016-03-01 00:00:00 | 8888 | ORANGES | 2 | 15
A115 | ABC STORE | 3654788 | 2016-03-01 00:00:00 | 8888 | ORANGES | 2 | 15
A115 | ABC STORE | 2051587 | 2016-02-01 00:00:00 | 8888 | ORANGES | 2 | 15
A115 | ABC STORE | 2051587 | 2016-02-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 2051587 | 2016-02-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 65478 | 2016-01-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 65478 | 2016-01-01 00:00:00 | 9999 | APPLES | 1 | 12
A115 | ABC STORE | 65478 | 2016-01-01 00:00:00 | 8888 | ORANGES | 2 | 15