Forum Discussion

sccoleman1189's avatar
sccoleman1189
Icon for Helper I rankHelper I
7 years ago
Solved

Show data past current date and approaching current date

Hello,

 

This may be a basic question but I need help creating 2 tables:

 

1. Table that shows data past current date (expired orders).

 

Ex. Current date 11/01/2020

Need Date         Order Num

10/29/2020         674d09

10/30/2020         8932de0

10/31/2020         7291w8

 

2. Orders that are within 7 days of current date (approaching need date).

Ex. Current date 11/01/2020

Need Date        Order Num

11/01/2020        6725gu

11/02/2020        786sw

11/04/2020        3782gd3

11/08/2020        317ge6

 

Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    7 years ago

    Hi sccoleman1189 ,

     

    I think you want to create two new tables from the raw table by the date. You can use CALCULATETABLE() function and add some conditions to get new tables.

    past =
CALCULATETABLE ( 'raw number', 'raw number'[Date] < TODAY () )
    within 7 days =
CALCULATETABLE (
    'raw number',
    'raw number'[Date] >= TODAY ()
        && 'raw number'[Date]
            <= ( TODAY () + 7 )
)

     

1 Reply

  • v-eachen-msft's avatar
    v-eachen-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi sccoleman1189 ,

     

    I think you want to create two new tables from the raw table by the date. You can use CALCULATETABLE() function and add some conditions to get new tables.

    past =
CALCULATETABLE ( 'raw number', 'raw number'[Date] < TODAY () )
    within 7 days =
CALCULATETABLE (
    'raw number',
    'raw number'[Date] >= TODAY ()
        && 'raw number'[Date]
            <= ( TODAY () + 7 )
)