Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
asdf1608
Helper V
Helper V

DateTrunc in power BI

I am converting the tableau functions to Power BI.

I am having doubts in this

dateadd('day',-1,datetrunc('month',dateadd('month',1,[Calendar day])))

How do I convert this to power DAX

For Example: if the  Calender day is 12/4/2022, after dateadd('month',1,{Calender day]) the month gets added by 1. So the answer is "12/5/2022" then  datetrunced by month "1/5/2022". For dateadd the date is substracted by -1. So the final answer is 30/4/2022.

if date = 3/6/2019 answer  after dateadd= 30/6/2019

How do I achieve this in power BI?

1 ACCEPTED SOLUTION
Mahesh0016
Super User
Super User

@asdf1608  in power bi End of Month Dax function 

End Date = ENDOFMONTH('Date'[Date])

Mahesh0016_0-1683622674955.png

 

View solution in original post

2 REPLIES 2
Mahesh0016
Super User
Super User

@asdf1608  in power bi End of Month Dax function 

End Date = ENDOFMONTH('Date'[Date])

Mahesh0016_0-1683622674955.png

 

johnt75
Super User
Super User

For this use case you want EOMONTH([Calendar day],0).

As a more general example you can build dates like

DATE( YEAR([Calendar date]), MONTH([Calendar date]) + 1, DAY([Calendar date]))

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors