Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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))
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...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.