Forum Discussion

sam_nik12345's avatar
sam_nik12345
Helper II
4 years ago
Solved

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 ...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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's avatar
sam_nik12345
Helper II
4 years ago

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.