Fill Tranformation like operation needed in DAX

[Anonymous]

Hi,

So if you know there is fill transformation that can fill the blanks with the same value below it. Im looking for something similar but in DAX

Here is the dataset

Feature ID	User Story	Commence Date	Output
FID001	200	2/9/2021	2/9/2021
FID001	202		2/9/2021
FID001	203		2/9/2021
FID002			2/10/2021
FID002	200	2/10/2021	2/10/2021
FID002			2/10/2021
FID002			2/10/2021
FID003	203		-
FID003	204		-
FID003	205		-
FID003	206		-

I have Feature ID and each Feature ID has some User Stories.

Out of those, only the 200 user stories have dates. If there is no 200 user story then there is no date for that feature

I want to extend the same date for all other user stories that belong to the same feature id. How can i acheive it? Output column is given for reference

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

According to your description and sample data, I can understand what you want to get, you want to use DAX to fill down the value of [ Commence Date] that have the same Feature ID, right?

You can try this calculated column:

This is my test data:

Output =

CALCULATE(

    MAX('Table'[Commence Date]),

    FILTER(

        ALL('Table'),

        [Feature ID]=EARLIER('Table'[Feature ID] )))

Then change the column data type to “Date”, and you can get what you want, like this:

You can download my test pbix file here

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.

[Anonymous]

Thnaks @v-robertq-msft can you also explain the filter part of the calculation