Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Current & previous months

Hi All, Does anyone know how to find current period and previous period total sales  by making your data table autoupdate?  For example, the first pay period starts from 1st to 15th of each mon...
Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi Anonymous 

    My understanding is that you need something like below.

    pay period = 
IF( DAY( 'Table'[Date] ) <= 15, "P1", "P2" )

    If not please please can you create a sample with the outcome that you are expecting.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

Mariusz's avatar
Mariusz
Community Champion
7 years ago

Hi Anonymous 

My understanding is that you need something like below.

pay period = 
IF( DAY( 'Table'[Date] ) <= 15, "P1", "P2" )

If not please please can you create a sample with the outcome that you are expecting.

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski