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 beginning of each month, like this

 

 

Thanks and regards,

 

Yuss

  • 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

2 Replies