Forum Discussion

BenjaminFab45's avatar
BenjaminFab45
Frequent Visitor
8 years ago

Populate with first non blank

Hi,   On my dataset, several devices have GPS positions. This positions are not on each line as my device don't moove but for my dashboard I need to populate each line with GPS position. What is th...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Try this  :

 

Measure =
CALCULATE ( FIRSTNONBLANK ( ALL ( Table1[Column2] ), TRUE () ) )

 

 

Column2 is "Numbers" columns.

 

 

Thanks

Aditya

BenjaminFab45's avatar
BenjaminFab45
Frequent Visitor
8 years ago

Thanks for your help, How I must do to "filter" by ID ? Because in this case, the formula don't care about the IDs.

 

This is the results :

 

  • BenjaminFab45's avatar
    BenjaminFab45
    Frequent Visitor
    8 years ago

    I try this formula, I'm near of the goal, but not reach yet ! =D 

     

    Colonne = IF(ISBLANK(Feuil1[Column2]);CALCULATE( FIRSTNONBLANK(Feuil1[Column2]; TRUE()); FILTER(Feuil1;Feuil1[Column1] = EARLIER(Feuil1[Column1])));Feuil1[Column2])

     

    Result : 

     

     

    The issue is for example with the first line "A / Null / 15", the result must be "A / Null / 21".

    Do you know why I only get "15" and not the last value ?

     

    Thanks

    • BenjaminFab45's avatar
      BenjaminFab45
      Frequent Visitor
      8 years ago

      After some tests I think I need to sort my table with date (not visible on this sample dataset) because I Think power bi by default sort by..... something but not know which.

       

      I'm right ? If yes, how I can sort data by date ?