Forum Discussion

ruesaint_denis's avatar
ruesaint_denis
Icon for Helper I rankHelper I
4 years ago
Solved

Fill in values if rows the same for a particular column

Hi everyone,    I have a Date column that I would like to fill with values, if the values in the column "Subject" are the same. Here's a screenshot of my data:    The first row has subject...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    ruesaint_denis , For each date create new column in DAX like

     


    new start time =
    var _max = maxx(filter(table, [subject] =earlier([subject]) && not(isblank([Start Date Email]))), [Start Date Email])
    return
    if(isblank([Start Date Email]), _max, [Start Date Email])

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

ruesaint_denis , For each date create new column in DAX like

 


new start time =
var _max = maxx(filter(table, [subject] =earlier([subject]) && not(isblank([Start Date Email]))), [Start Date Email])
return
if(isblank([Start Date Email]), _max, [Start Date Email])