Forum Discussion

MichaelF1's avatar
MichaelF1
Helper III
2 years ago
Solved

Dax or Power Query - Ranking by date for each category

I'm looking at how often different products were ordered over a given date range.    I want to give a rank to each time a distinct product was ordered.   So I have:   date product date 1...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi MichaelF1 

     

    Please try this:

    Here I create a calculated column:

    Column = 
	RANKX(
		FILTER(
			ALLSELECTED('Table'),
			'Table'[product] = EARLIER('Table'[product])
		),
		MID(
			'Table'[date],
			6,
			2
		),
		,
		ASC
	)

    The result is as follow:

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi MichaelF1 

 

Please try this:

Here I create a calculated column:

Column = 
	RANKX(
		FILTER(
			ALLSELECTED('Table'),
			'Table'[product] = EARLIER('Table'[product])
		),
		MID(
			'Table'[date],
			6,
			2
		),
		,
		ASC
	)

The result is as follow:

 

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.