Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
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.![]()
Regards
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 104 | |
| 82 | |
| 72 | |
| 46 | |
| 35 |