Forum Discussion

zanottiluca's avatar
zanottiluca
Icon for Helper II rankHelper II
7 years ago
Solved

Retrieve last record based on 2 sortings

Hi guys,  I am struggling with a DAX computation: in brief I would like to retrieve the latest record in a group by two sorting order. The first is based on the Invoice number descending, but if wit...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    zanottiluca 

     

    try this as Calculated Table

     

    Calculated Table = 
GENERATE (
SELECTCOLUMNS ( VALUES ( 'Table1'[Groupid]), "Groupid_", [Groupid] ),
CALCULATETABLE ( TOPN ( 1, 'Table1', [InvoiceN], DESC,[Modified Date],DESC ) )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

zanottiluca 

 

try this as Calculated Table

 

Calculated Table = 
GENERATE (
SELECTCOLUMNS ( VALUES ( 'Table1'[Groupid]), "Groupid_", [Groupid] ),
CALCULATETABLE ( TOPN ( 1, 'Table1', [InvoiceN], DESC,[Modified Date],DESC ) )
)
zanottiluca's avatar
zanottiluca
Icon for Helper II rankHelper II
7 years ago

Hi, 

 

Zubair_Muhammad . many thanks for this it worked and you opened a new "world" about calculated tables.

 

Many thanks for this

Luca

Zubair_Muhammad wrote:

zanottiluca 

 

try this as Calculated Table

 

Calculated Table = 
GENERATE (
SELECTCOLUMNS ( VALUES ( 'Table1'[Groupid]), "Groupid_", [Groupid] ),
CALCULATETABLE ( TOPN ( 1, 'Table1', [InvoiceN], DESC,[Modified Date],DESC ) )
)
Zubair_Muhammad wrote: