LARGE and SMALL Excel to DAX

[Greg_Deckler]

Two more for the Excel to DAX translation! A nifty double secret RANKX pattern...

• LARGE
• SMALL

[Anonymous]

Hi @Greg_Deckler thanks a lot for sharing the large function!! I was actually looking for the similar function. 

But with slight variation, hope you can help me out. 

I have a table with cols as- as_of, name, value1 and value2. For a single as_of and name there can be multiple values. 

Now I want to create another cols as combined values and sequence no. 

Sequence no - contains count of all the values based on value 1 and value 2 cols (u can say aa index) . 

Combined values- contains appended values(after values of value1 additional rows were inserted to append the values of value2 col) of value 1 and value 2 col. And these appended values should be arranged based on sequence no.