Forum Discussion

okl's avatar
okl
Frequent Visitor
3 years ago
Solved

Display previous week value in a Card

Hi there I have  a Date table as below and some measurements with SalesVolume  and the percentage changes example YOY % How do I show the previous Fiscal Year Week Number YoY % value in a card, exa...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi okl ，

     

    You can filter the previous week by subtracting the current week number by one.

    For example, if you need to return sales for the previous week, you can create a measure.

    PreviousWeek =
CALCULATE (
    SUM ( 'Table'[Sales] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        [Fiscal Year Week Number]
            = MAX ( 'Table'[Fiscal Year Week Number] ) - 1
    )
)

     

       

       

                                                                                                                                                             

    Best Regards,

    Stephen Tao

     

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

                                                                                                                                                             

    Best Regards,

    Stephen Tao

     

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

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi okl ，

 

You can filter the previous week by subtracting the current week number by one.

For example, if you need to return sales for the previous week, you can create a measure.

PreviousWeek =
CALCULATE (
    SUM ( 'Table'[Sales] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        [Fiscal Year Week Number]
            = MAX ( 'Table'[Fiscal Year Week Number] ) - 1
    )
)

 

   

   

                                                                                                                                                         

Best Regards,

Stephen Tao

 

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

                                                                                                                                                         

Best Regards,

Stephen Tao

 

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