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?