Forum Discussion

sdlx's avatar
sdlx
Helper I
6 years ago

Max value except if null

I have one product with different date and I need to have only the maximum date for this product. The specificity is that for some product i have a date showing as "null" and in that case i need the ...
Need Help
vivran22's avatar
vivran22
Community Champion
6 years ago

Hellosdlx 

 

 

I have created a sample data for this:

 

 

 

MAX Date = MAXX(Sheet1,IF(COUNTBLANK(Sheet1[Date]) = 0,Sheet1[Date]))

 

 

You should get the following result:

 

 

Regards,
Vivek

If it helps, please mark it as a solution

Kudos would be a cherry on the top 🙂

https://www.vivran.in/

sdlx's avatar
sdlx
Helper I
6 years ago

Hello,

 

Thanks, it works !

I am noticing now that it would help me if I could have the same result as an addedd colum in the query editor.

In that colum I would have the maximum date for the product if no Null value.

If there is a null value for one line of a product then I would have null for all the line of this product.

 

Would you have an idea for that ?

vivran22 v-eachen-msft  amitchandak