Forum Discussion
Same Peeriod Last Year Filtered by Many Columns
Anonymous , Find the file again
if you need more help make me @
Appreciate your Kudos.
Please make up data that is not your actual data that emulates the problem. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Greg_Deckler below is the emulated data. I need to get the sales for the same time last year filtered by the different columns (i.e. product, currency, country, etc.)
Thank you so much for your help!
| Country | Product | Currency Purchase | Month | Sales |
| USA | A | USD | 1/1/2020 | 3000 |
| USA | A | USD | 1/1/2019 | 2000 |
| France | B | EUR | 1/1/2020 | 1000 |
| France | B | EUR | 1/1/2019 | 500 |
| USA | B | EUR | 1/1/2020 | 1500 |
| USA | B | EUR | 1/1/2019 | 4000 |
| France | C | EUR | 1/1/2020 | 750 |
| France | C | EUR | 1/1/2019 | 200 |
Anonymous , Please see if attached file can help
amitchandak thank you for your response and work.
If you had to create another column in the table called Sales LY rather than measure would you do it differently?
Anonymous , Find the file again
if you need more help make me @
Appreciate your Kudos.