Forum Discussion

jyaul786's avatar
jyaul786
Icon for Helper II rankHelper II
3 years ago

Dax to remove blank cell

Dear Friends,  i have calendar table: Calendar(Date) and i would like to get always minimum date when select by slicer. so that i wrote measure: Min_Date=CALCULATE(MIN('Calendar'[Date]),ALL('Calend...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi jyaul786 ,

 

I couldn't reproduce your issue on myside. I think your issue should be caused by your data model.

I suggest you to try code as below.

Min_Date =
IF (
    MAX ( 'Calendar'[Date] ) = BLANK (),
    BLANK (),
    CALCULATE ( MIN ( 'Calendar'[Date] ), ALL ( 'Calendar' ) )
)

 

Best Regards,
Rico Zhou

 

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