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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Honey
Regular Visitor

How to add years to min date function and use that in other calculation

Hi friends,
I am new to power bi and I have a requirement below :

Honey_0-1663589525141.png

here FOB value is given against each year .
I need to calculate other two columns (Avg Export Obligation achieved and SEO achieved for upcoming 6 years).
My idea is to get the min year so that I can find the least year and then I can use the dateadd function to calculate upcoming years.but I am not able to use MIN year function in my main calculation so that I can find these two values for each year.
Can you please help me?
Thanks Calculations using DAX 


@dax .







1 REPLY 1
Anonymous
Not applicable

Hi @Honey ,


Would you please explain how to gets the two columns? Thanks.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.