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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Employee
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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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