Forum Discussion

Erik70's avatar
Erik70
Frequent Visitor
4 years ago
Solved

same day last year

Hi, im struggling to get this "same day last year" to work. i have ordersum and if i set filters manually it will show the correct value but i want it to automatically look at todays date and show ...
  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    3 years ago

    Hi Erik70 ,

     

    According to your description, I created a sample and here is my solution.

    Create a measure.

    measure =
SUMX (
    FILTER (
        ALL ( 'PBI_kundorder' ),
        [Upplagd] = EDATE ( MAX ( 'PBI_kundorder'[Upplagd] ), -12 )
    ),
    [Ordersumma]
)

    Final output:

     

    I attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ xiaosun

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xiaosun-msft's avatar
v-xiaosun-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi Erik70 ,

 

According to your description, I created a sample and here is my solution.

Create a measure.

measure =
SUMX (
    FILTER (
        ALL ( 'PBI_kundorder' ),
        [Upplagd] = EDATE ( MAX ( 'PBI_kundorder'[Upplagd] ), -12 )
    ),
    [Ordersumma]
)

Final output:

 

I attach my sample below for your reference.

 

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.