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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
craig811
Helper III
Helper III

How to create my Excel Index formula in Power Query

Hi,

 

I am how do I recreate my Index Excel formula that looks to my Power Pivot in Power Query:

INDEX('PQ Pivot'!$1:$1048576,MATCH(G$1,'PQ Pivot'!$A:$A,0),MATCH($D3,'PQ Pivot'!$1:$1,0))/IF($D3=$D2,COUNTIF($D:$D,$D2),COUNTIFS($D:$D,$D3))

1 REPLY 1
Vera_33
Resident Rockstar
Resident Rockstar

Hi @craig811 

 

Please provide some sample data and expected results in a format we can copy, you can use dummy data. It's too difficult to understand...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors