Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Populate values in blank rows

Hi All,   I have 2 fields in my table as shown below.I have to create a new column which should populate the last non blank value. i.e: may (data) 50 should populate in a new column for all the mo...
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, Anonymous 

    According to your description, I can clearly understand your requirement, I think you can try my steps:

    1. Create a month column as the number type like this:
    Month=Month([Date])

     

    1. Create a calculated column like this:
    Column =

var _maxmonth=

MAXX(FILTER(ALL('Table'),[Amount]<>BLANK()),[Month])

return

SUMX(FILTER(ALL('Table'),[Month]=_maxmonth),[Amount])

     

    And you can get what you want.

    You can download my test pbix file below

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

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

v-robertq-msft's avatar
v-robertq-msft
Community Support
5 years ago

Hi, Anonymous 

According to your description, I can clearly understand your requirement, I think you can try my steps:

  1. Create a month column as the number type like this:
Month=Month([Date])

 

  1. Create a calculated column like this:
Column =

var _maxmonth=

MAXX(FILTER(ALL('Table'),[Amount]<>BLANK()),[Month])

return

SUMX(FILTER(ALL('Table'),[Month]=_maxmonth),[Amount])

 

And you can get what you want.

You can download my test pbix file below

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

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