Forum Discussion

Hennadii's avatar
Hennadii
Icon for Helper IV rankHelper IV
6 years ago
Solved

Create a table with dates based on Start / End Dates and Values on another Table

Hi there, I have a Period table with Star Date and End Date columns. Periods are not overlap each other, so each date is related to certain Period. Period Start Date End Date period 1 01/0...
Date
DAX
power bi
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Perhaps:

     

     

    Calendar Table = 
  ADDCOLUMNS(
    CALENDAR(DATE(2020,1,1),DATE(2020,12,31)),
    "Period",MAXX(FILTER('Table',[Start Date]<=[Date] && [End Date]>=[Date]),[Period])
  )

    Hennadii 

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Perhaps:

 

 

Calendar Table = 
  ADDCOLUMNS(
    CALENDAR(DATE(2020,1,1),DATE(2020,12,31)),
    "Period",MAXX(FILTER('Table',[Start Date]<=[Date] && [End Date]>=[Date]),[Period])
  )

Hennadii 

 

Hennadii's avatar
Hennadii
Icon for Helper IV rankHelper IV
6 years ago

Greg_Deckler ,
Is there a way to do not hardcode dates in expression?