topic Re: Data connectivity - Total Yearly Value in DAX Commands and Tips

Data connectivity - Total Yearly Value

Anonymous — Wed, 02 Dec 2020 09:32:56 GMT

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:

Calendar = CALENDAR(DATE(2020,1,1),DATE(2022,12,31))
and then I extracted "Year" using DAX command:

Calendar Yer = YEAR('Calendar'[Date])

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?

Re: Data connectivity - Total Yearly Value

amitchandak — Wed, 02 Dec 2020 10:37:23 GMT

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

Re: Data connectivity - Total Yearly Value

Anonymous — Fri, 11 Dec 2020 07:44:47 GMT

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: