Forum Discussion
same value repeating issue
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 |
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.
4 Replies
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
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.
sam_nik12345 , Add month year to date tbale and use.
Please find the attached file after signature
Month Year = FORMAT([Date], "YYYY-MM")
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.
