Forum Discussion

DmitryAD7's avatar
DmitryAD7
Icon for Helper I rankHelper I
2 years ago
Solved

Custom Date Period

Hello community,   Please help, I need to create a table with custom periods: Last 15 Months Previous 15 Months Years   I create all I needed in the calendar table:   Calendar = ADDC...
  • xifeng_L's avatar
    xifeng_L
    2 years ago

    Hi DmitryAD7 

     

    Is this the result you want?

     

     

    If yes, you can use the below code:

     

    Custom Periods = 
UNION (
    ADDCOLUMNS (
        FILTER('Calendar','Calendar'[Last 15 Months]<>BLANK()),
        "Custom Period", 'Calendar'[Last 15 Months],
        "Sort", 1
    ),
    ADDCOLUMNS (
        FILTER('Calendar','Calendar'[Previous 15 Months]<>BLANK()),
        "Custom Period", 'Calendar'[Previous 15 Months],
        "Sort", 2
    ),
    ADDCOLUMNS ( 'Calendar', "Custom Period", 'Calendar'[Year], "Sort", 3 )
)

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi DmitryAD7 

 

I don't quite understand what your needs are, could you please show the result you want in excel form?  That would be very helpful. Thank you for your time and efforts in advance.

 

Best Regards,
Yulia Xu