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
Galat198
Helper IV
Helper IV

Dax: Calculate page row by page location

Hi,

I have products on a page, each row has 3 products
I know the general position of the product on the page
How can I calculate and mark which row a product is in?

For example products in position 1-3 is the first row, 4-6 is the second row.....
Use IF or SWITCH is not suitable because there are lots of products and rows.

Galat198_0-1629796207060.png

 



1 ACCEPTED SOLUTION

@Galat198 , Try

row = Quotient([page position]+2 ,3)

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@Galat198 , based on what I got ,

A new column in date should help

row = Quotient([page position],3)

@amitchandak 

Galat198_0-1629800269123.pngGalat198_1-1629800299042.png

It makes a mistake of two positions

@Galat198 , Try

row = Quotient([page position]+2 ,3)

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.