Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to use the Excel's MAX function in DAX

Hi everyone, 

 

I need your help in translating the MAX function within the IF function which is currently on a spreadsheet to be converted in to a DAX function.

 

Thanks. 

Sumanth

 

 

AVAIL INVENTORY UNITS / (UNITS SOLD FOR SET TIME FRAME / IF ( (MAX( [BIRTHDATE], [1ST INV DATE] ) > START YYYYMMDD , END YYYYMMDD - (MAX( [BIRTHDATE], [1ST INV DATE] ) , END YYYYMMDD - START YYYYMMDD))

Need Help

3 Replies

  • rajend12's avatar
    rajend12
    Icon for Helper III rankHelper III
    5 years ago

    Hey Anonymous ,

     

    Can you please elaborate on what problem you are trying to solve?

    Can you give the Excel function you are using now,,,

     

    Cheers,

    Deepan

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      rajend12  I am trying to calculate Days of Sales measure. It needs inventory units, sold item quantity within the selected date range, and the last piece is the formula plugged in above. I am currently not using any excel function but need to translate this piece of logic to DAX.  Heres a preview of the data. I need to use either Birthdate or FirstInventoryDate based on the logic I provided above to calculate the measure. 

      • v-robertq-msft's avatar
        v-robertq-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi, Anonymous 

        Would you like to translate your logic into normal language, so that I can understand what's your actual demand?

        If you want us to solve your question quickly, you can post some sample data in the table format(without sensitive data) and your expected result.

        How to Get Your Question Answered Quickly 

         

        Best Regards,

        Community Support Team _Robert Qin

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.