I am currently working on getting the latest two months' data and show it on Waterfall chart.
Lets say this table is named as "Game"
| Month | Name | Game | Points | Goal | Mark |
| Jan-19 | Mary | Basketball | 10 | | x |
| Jan-19 | Mary | Dancing | 20 | | x |
| Jan-19 | Samuel | Running | 20 | | x |
| Jan-19 | Samuel | Dancing | 20 | | x |
| Jan-19 | Samuel | Karake | 10 | | x |
| Jan-19 | Samuel | Running | 5 | | x |
| Jan-19 | Rikka | Dancing | 15 | | x |
| Jan-19 | Nicky | Karake | 35 | | x |
| Feb-19 | Ricky | Karake | 20 | | x |
| Feb-19 | Ricky | Basketball | 5 | | x |
I have the data until MARCH 2019 only. I will update data in April in beginning of May. Assume it is now end of April and I
still do not have data in April
I have appended table below "Goal" into "Game" later and so that I can put goal as target in Gauge to check if the target is reached in the month or not.
| Jan-19 | | Dancing | | 300 |
| Jan-19 | | Karake | | 200 |
| Jan-19 | | Running | | 400 |
| Jan-19 | | Basketball | | 500 |
| Feb-19 | | Dancing | | 300 |
| Feb-19 | | Karake | | 200 |
| Feb-19 | | Running | | 400 |
| Feb-19 | | Basketball | | 500 |
| Mar-19 | | Dancing | | 300 |
| Mar-19 | | Karake | | 200 |
...........
| Jun-19 | | Running | | 400 |
| Jun-19 | | Basketball | | 500 |
Given by the situation, is it possible for me to look into the Waterfall Chart of March and February only at the end of April? After I update the data in May, I would expect to have Waterfall Chart of April and March, that it will always show the latest two months with points automatically after I manually update the data.
Highly appreciate if there is any DAX solution for the question. Many thanks.
