Forum Discussion
Anonymous
6 years agoNot applicable
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 what I can do please? Your support is truly appreciated. I was w
| Month | Actual Date | Source | Hours | Estimated Hours | Cost |
| 2/1/19 | 2/5/19 | PR | 8 | ||
| 2/1/19 | 2/6/19 | PR | 8 | ||
| 7/1/18 | 7/1/18 | OE | 200 | 5000 |
3 Replies
- Greg_DecklerCommunity Champion
I 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
- AnonymousNot applicable
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 - AnonymousNot applicable
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?