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
Ait-james
Frequent Visitor

Calculate half year

Hello everyone,

 

I need help please, it's regarding last day of current half year how can calculat it ? I had searched but I can't find anything.

 

Thank you !

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

If you need jun

Measure 4 = EOMONTH(date(YEAR(TODAY()),6,1),0)

 

If you need after 6 month

Measure 4 = EOMONTH(date(YEAR(TODAY()),Month(TODAY())+6,1),0)

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @

Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

If you need jun

Measure 4 = EOMONTH(date(YEAR(TODAY()),6,1),0)

 

If you need after 6 month

Measure 4 = EOMONTH(date(YEAR(TODAY()),Month(TODAY())+6,1),0)

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @

Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin

Thank you, it's working well !

Anonymous
Not applicable

Do you have a date dimension? Do you basically want to know the ...date of 30th of June?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.