Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Measure to get value from right column with value

Hi,

I have simple measure for Cost per unit = DIVIDE(SUM([EXT_LINE_COST]),SUM([RECEIVED_QTY])), I want to fill the blanks in it with available value from right coloumn. For example in attached snip, the first row should have $1.86 from column 202008 to 202108. I have Date table connected. Can someone please help me write the measure?

 

 

 

  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous ,  Try like

     

    if(isblank([Cost per unit]) , calculate(lastnonblankvalue(Date[Year Month], [Cost per unit]) , filter(all('Date'), Date[Month Year] <= Max(Date[Year Month]) ) ) , [Cost per unit])

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous ,  Try like

     

    if(isblank([Cost per unit]) , calculate(lastnonblankvalue(Date[Year Month], [Cost per unit]) , filter(all('Date'), Date[Month Year] <= Max(Date[Year Month]) ) ) , [Cost per unit])

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    amitchandak 

    Hi Amit,

    Thank you for the soloution. I used the measure you provided (I named it Cost) and it almost worked. the total for Cost measure is summing the values from Cost. Is it possibel to SUM the values of Cost Measure?