Forum Discussion
Values return in blank becuase different date
Hello there! I urgently need your help with this. I need in anyway place the values of the source OE parallel with the source PR because is giving me the values in blank. It is the same table, then...
Greg_Deckler
Community Champion
Community ChampionI am not clear on the requirement. Is that sample source data? If so, what is the expected result you are trying to achieve? 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
Mth | Store | ProductID | TransID | TransType | SalesDate | UnitDescriptio | UnitsSold | UnitsGoal | SalesGoal |
| 3/1/2020 | 4001 | 201 | 12535 | DT | 3/5/2020 | Shampoo | 2 | ||
| 3/1/2020 | 4001 | 201 | 34546 | DT | 3/8/2020 | Shampoo | 1 | ||
| 3/1/2020 | 4001 | 201 | 88343 | DT | 3/9/2020 | Shampoo | 1 | ||
| 3/1/2020 | 4001 | 201 | 96796 | DT | 3/20/2020 | Shampoo | 2 | ||
| 7/1/2019 | 4001 | 201 | 24567 | OE | 7/1/2019 | 200 | $ 820.00 |
Greg_decker The issue that Im having is when I put a visualization of the unit/sales goals came out in blank due to the diffrence of dates and source. Is there a way?