Anything related to PowerPivot and DAX Formuale
Posts: 1
Joined: Tue Dec 17, 2019 6:55 am


Postby kt2019 » Tue Dec 17, 2019 7:12 am


I am new to power pivot/Dax , so please forgive me if I have some unrealistic or dump questions.

I am comparing between two rows from the sale order field. If the first row = second row, then set value from Refe column to 0, if not then set to 1
I have google but got no luck, can you please help?
Capture.PNG (2.32 KiB) Viewed 342 times

Bernard Heymans
Posts: 34
Joined: Wed Feb 28, 2018 12:18 am

Re: Row()

Postby Bernard Heymans » Thu Jan 02, 2020 3:01 am

Not even sure the concept of row exist...

The only solution I see is to create 2 measures & compare them.

like fuel use of cars.
then fuel use of red cars, & fuel use of blue cars,
finally compare red cars to blue ones...

Posts: 55
Joined: Thu Oct 19, 2017 12:57 pm

Re: Row()

Postby RamanaV » Thu Jan 02, 2020 8:46 am

This problem can be solved in Power Query before loading the data into the data model. The trick is to use "Nested Index", which I learnt from Matt Allington in his Power Query Online Training course. ... e-training.

Please find the solution in the attached sample workbook.

Row() by Nested Index.xlsx
(27.06 KiB) Downloaded 17 times
Ramana Varanasi
Training and Office Manager
Excelerator BI Pty. Ltd.

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 6 guests