Forum Discussion

mikaelhyensjo's avatar
mikaelhyensjo
Frequent Visitor
9 years ago

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.

 

 

Need Help

1 Reply

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    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.:smileyhappy:

     

    Regards