Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

How to get same value as above row

Hi all,

 

Below i have 2 data of order (10000776769 & 10000589016).  How can I get all actual date row follow the same date as ZN01 date.

 

Current Actual date formula: if AFVC="ZN01" then Date else 0

 

OrderAFVCValueDateActual Date
10000776769ZN0105/6/20235/6/2023
10000776769ZN0207/6/20230
10000776769ZN0307/6/20230
10000776769ZN0437/6/20230
10000776769ZN05567/6/20230
10000776769ZN0607/6/20230
10000776769ZN0707/6/20230
10000776769ZN0807/6/20230
10000776769ZN0907/6/20230
10000776769ZN10787/6/20230
10000776769ZN1117/6/20230
10000776769ZN1207/6/20230
10000776769ZN1307/6/20230
10000589016ZN0102/6/20232/6/2023
10000589016ZN0203/6/20230
10000589016ZN0303/6/20230
10000589016ZN0403/6/20230
10000589016ZN0523/6/20230
10000589016ZN0603/6/20230
10000589016ZN0703/6/20230
10000589016ZN08293/6/20230
10000589016ZN0913/6/20230
10000589016ZN10663/6/20230
10000589016ZN1103/6/20230
10000589016ZN1203/6/20230
10000589016ZN1303/6/20230

 

Regards,

Nuha

4 REPLIES 4
m_dekorte
Super User
Super User

Hi @Anonymous,

 

If you want to repeat the same "Actual date" for the other order records, use null instead of 0 in your conditional column and subsequently select the fill down option. Note that this requires there has to be an AFVC="ZN01" for each order in your table.

Anonymous
Not applicable

hI @m_dekorte , 

 

I dont think your solution will solve my issue here. I do change the value 0 to NULL but I still stuck at this point. I want the value as below image aligned in each row (3 rows = 3 different date = 1 production order)

 

nuhasan_0-1686494318722.png

 

Regards,

Nuha

 

 

Right click the column header/ Fill/ Down

m_dekorte_0-1686518646179.png

 

Anonymous
Not applicable

Hi @m_dekorte ,

 

Already done the step but it not fulfill my requirement. This is because not all date are in sequence as below. 

 

OrderAFVCValueDateActual Date
10000776769ZN05   
10000776769ZN0207/6/20230
10000776769ZN0307/6/20230
10000776769ZN0437/6/20230
10000776769ZN13567/6/20230
10000776769ZN0607/6/20230
10000776769ZN0707/6/20230
10000776769ZN0807/6/20230
10000776769ZN0907/6/20230
10000776769ZN10787/6/20230
10000776769ZN1117/6/20230
10000776769ZN1207/6/20230
10000776769ZN0105/6/20235/6/2023
10000589016ZN0102/6/20232/6/2023
10000589016ZN0203/6/20230
10000589016ZN0303/6/20230
10000589016ZN0403/6/20230
10000589016ZN0523/6/20230
10000589016ZN0603/6/20230
10000589016ZN0703/6/20230
10000589016ZN08293/6/20230
10000589016ZN0913/6/20230
10000589016ZN10663/6/20230
10000589016ZN1103/6/20230
10000589016ZN1203/6/20230
10000589016ZN1303/6/20230

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.