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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors