Convert SQL Row_Number to DAX

[Harry_Tran]

Hi,

I have a SQL Query like this:

SalebyInvoice = Sum ( Sales ) OVER ( Partition by Invoice order by SaleDate ASC )

How can I convert this to DAX?

Thanks

[Mikelytics]

Hi @Harry_Tran 

Please see below an example with two categroy fields

Best regards

Michael

-----------------------------------------------------

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

Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn

[Mikelytics · Accepted solution]

HI @Harry_Tran 

Please try:

Sum Over=
CALCULATE(
   SUM(SalesTable[ValueColumn]),
   ALL(SalesTable[InvoiceOrder]),
   ALL(SalesTable[SaleDate])
)

If this does not help can you please sind some more info like data model and the result you intend to have in Power BI?

@Harry_Tran Forgot a bracket and had to update the formula.

Best regards

Michael

Best regards

Michael

-----------------------------------------------------

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

Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn