cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Fill Tranformation like operation needed in DAX

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 IDUser StoryCommence DateOutput
FID0012002/9/20212/9/2021
FID001202 2/9/2021
FID001203 2/9/2021
FID002  2/10/2021
FID0022002/10/20212/10/2021
FID002  2/10/2021
FID002  2/10/2021
FID003203 -
FID003204 -
FID003205 -
FID003206 -

 

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

1 ACCEPTED SOLUTION
v-robertq-msft
Community Support
Community Support

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:

v-robertq-msft_0-1613098503191.png

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:

v-robertq-msft_1-1613098503203.png

 

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.

View solution in original post

2 REPLIES 2
v-robertq-msft
Community Support
Community Support

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:

v-robertq-msft_0-1613098503191.png

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:

v-robertq-msft_1-1613098503203.png

 

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.

View solution in original post

Anonymous
Not applicable

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

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors