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 198 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: 48
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 7 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 2 guests