Forum Discussion

AndresSalomon's avatar
AndresSalomon
Helper II
8 years ago
Solved

First non blank value

Hi Community, need your help to solve a problem. I think is prety simple but I'm not being able to solve it.   My scenario is the next one. I have this table. Name ID___________Month_______Date ...
Need Help
  • Rich_P's avatar
    Rich_P
    8 years ago

     

    Here is the DAX Formula I used.

    FirstDateByName:=CALCULATE(FIRSTDATE(Table2[Date]),ALL(Table2[Month]),ALL(Table2[Date]))

    There is probably a better way, but this works. Hope it heloped.

     

    Rich

  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    This calculated column formula will work

     

    =CALCULATE(MIN([Date]),FILTER(Data,Data[Name ID]=EARLIER(Data[Name ID])))

    Hope this helps.

AndresSalomon's avatar
AndresSalomon
Helper II
8 years ago

Hey guys, really thaks for the help! I think both of your ideas can work but, FOR ME, I prefer to avoid using EARLIER fuction. It always brings me problems. 

 

Anyway both are great solutions. 

 

Thanks again. 

 

Kind regards,

 

Andy.-

Rich_P's avatar
Rich_P
Helper II
8 years ago

Always happy to help (where I can). Gotta love this site and the members!