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.

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.

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.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.