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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
easonzeng
Regular Visitor

Could you support me to convert an excel formula to Power Query?

I need to convert this Excel formula into Power Query in dataflow.

=MINIFS(data[Date],data[Date],">="&data[@Date],data[Unbooked],1,data[Department],data[@Department],data[Store],data[@Store])

I have tried multiple ways to do it, including group by, but had no luck.

I would appreciate it if anyone could provide some insights.

Thank you.

Otic

1 REPLY 1
wdx223_Daniel
Super User
Super User

NewStep=let a=Table.Group(data,{"Unbooked","Department","Store"},{"n",each List.Sort([Date])}) in Table.AddColumn(data,"newCol",each let b=a{[Unbooked=1,Department=[Department],Store=[Store]]}?[n]? in if b=null then b else List.Skip(b,(x)=>x<[Date]){0}?)

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors