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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
mikaelhyensjo
Frequent Visitor

DAX with columns

Hi.

 

I have a report with Forecast run dates and in my report I have selected two run dates. I need a formula

which gives my the lowest value of the selected run date on selected row. Will have possibility to change from week 

to item group and then it should show the lowest value on the selected item group.

 

 

 New column with the lowest of the two run dates. Now we have date on rows but will also be possible to change to item group etc.Skärmavbild 2017-01-29 kl. 08.29.02.png

 

 

1 REPLY 1
v-ljerr-msft
Microsoft Employee
Microsoft Employee

Hi @mikaelhyensjo,

 

Could you post your table structures with some sample data and your expected result? It's better to share a sample pbix file. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.Smiley Happy

 

Regards

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors