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
DAMA_KIM
Regular Visitor

Power Query: How to add a calculated row?

HI, Power BI professionals~

I have +300,000 pieces of order information. 
I am analyzing the savings compared to the unit amount of the previous month.

 

1. The left side is my data. Right side is the data want to create.

2. All data is generated additionally by the [EndPeriod]. => Flag : Add 
 - ex) the data of [Category = AAA & Index  = 1] will only be checked for additional orders until [EndPeriod] = 202304.

3. [Dif.Amt] is the difference from the [AMT] in the previous index.

 

DAMA_KIM_1-1691036399705.png

 

I'm waiting for your help.

1 REPLY 1
Mkarwa-123
Resolver II
Resolver II

Hello @DAMA_KIM 
You can try duplicate left file , create new flag based on your condition, remove old flag and then append these 2 tables together.

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.