Forum Discussion

Yusissa's avatar
Yusissa
Frequent Visitor
8 years ago
Solved

Group dates to Month

Hello All,   Quick question since Im a beginner in Power Bi,    I have a range of dates in one table shown as this...   Im Interested in having a column in another table just showing the ...
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI Yusissa,

     

    You can use below formula to create new table with first date of each month:

    NewTable=
FILTER (
    CALENDAR (
        DATE ( YEAR ( FIRSTDATE ( 'Table'[Date] ) ), 1, 1 ),
        DATE ( YEAR ( LASTDATE ( 'Table'[Date] ) ), 12, 31 )
    ),
    DAY ( [Date] ) = 1
)

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Yusissa,

 

You can use below formula to create new table with first date of each month:

NewTable=
FILTER (
    CALENDAR (
        DATE ( YEAR ( FIRSTDATE ( 'Table'[Date] ) ), 1, 1 ),
        DATE ( YEAR ( LASTDATE ( 'Table'[Date] ) ), 12, 31 )
    ),
    DAY ( [Date] ) = 1
)

 

Regards,

Xiaoxin Sheng