same value repeating issue

[sam_nik12345]

My sales and po tables looks like below:

date	sales
2018-01	12
2018-02	23
2018-03	34
2018-04	45
2018-05	55

date	p/o
2018-02	44
2018-03	23
2018-05	22

When I combine the visualization I get only total p/o values in all rows as below.

date	sales	p/o
2018-01	12	89
2018-02	23	89
2018-03	34	89
2018-04	45	89
2018-05	55	89

Can anyone help me solving this? Ideally it should look like below:

date	sales	p/o
2018-01	12
2018-02	23	44
2018-03	34	23
2018-04	45
2018-05	55	22

[v-yalanwu-msft · Accepted solution]

Hi， @sam_nik12345 ；

Alternatively, you only need to create a measure.   Note: No relationship is required.

Measure = CALCULATE(SUM('PO'[p/o]),FILTER('PO',EOMONTH([date],0)=EOMONTH(MAX('sales'[date]),0)))

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sam_nik12345]

Hi @amitchandak 

How do I aggregate this to month level? The value I get at daily and needs to be aggregated to month. Kinldy advice.

[amitchandak]

@sam_nik12345 , Add month year to date tbale and use.

Please find the attached file after signature

Month Year = FORMAT([Date], "YYYY-MM")

[amitchandak]

@sam_nik12345 , You have to create a common date table and join with both and then use measure from Sales and PO

Please find the file attached