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
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 ?

      • nirvana_moksh's avatar
        nirvana_moksh
        Icon for Impactful Individual rankImpactful Individual
        8 years ago

        Use the below DAX:

         

        CALCULATE(LASTNONBLANK('TableA'[Table A Column Name],1),FILTER('TableA','TableA'[Index] = MIN('TableA'[Index])))

         

        And in Power Query Editor define a Index Column which will serve as ID, then in the above DAX change MIN to MAX or vice versa based on your sort.