Forum Discussion
Data connectivity - Total Yearly Value
Hello Felows,
I've issue with data connectivity and I hope you will help me to resolve it.
Basically I've two data sets. First data set shows Actual Yearly QTY and second data set shows Target Yearly QTY.
Actual Yearly QTY
| Cal. Year | ID | QTY |
| 01-01-2020 | 301 | 15 |
| 01-01-2020 | 302 | 20 |
| 01-01-2020 | 303 | 30 |
| 01-02-2020 | 306 | 50 |
| 01-02-2020 | 308 | 5 |
| 01-03-2020 | 330 | 100 |
| 01-04-2020 | 331 | 3 |
Target Yearly QTY
| Cal. Year | ID | QTY Target |
| 2020 | 301 | 20 |
| 2020 | 302 | 60 |
| 2020 | 303 | 70 |
| 2020 | 306 | 15 |
| 2020 | 308 | 6 |
| 2020 | 330 | 7 |
| 2020 | 331 | 802 |
| 2021 | 301 | 36 |
| 2021 | 302 | 24 |
| 2021 | 303 | 98 |
| 2021 | 306 | 364 |
| 2021 | 308 | 35 |
| 2021 | 330 | 147 |
| 2021 | 331 | 57 |
The Target Yearly QTY is only indicating "Year" , is not full date. Accordingly I created a seperate table using the following DAX command:
and then I extracted "Year" using DAX command:
I've connected data sets, but the values in the report is not showing the correct outcome when I click on Year Slicers:
Any suggestions how to resolve it?
2 Replies
- amitchandak
Super User
Anonymous , Refer if my two blog on yearly target if the can help
PowerBI Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-Convert-to/ba-p/1476400
powerbi Distributing/Allocating the Yearly Target(Convert to Daily Target): https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to-Daily/ba-p/1463290
amitchandak , unfortunately your blog does not help or provide resolution to my issue.
As I mentioned above, I've two datasheets that I'm stuggling to connect.
I'm using slicer to visualize the Actual QTY and Target QTY for 2020,2021 & 2022 in the table.
The table only shows correct value for Target QTY but somehow summarizes Actual QTY:
