Forum Discussion
Helper IIIConvert SQL Row_Number to DAX
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
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.
-----------------------------------------------------
2 Replies
- Mikelytics
Resident Rockstar
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.
-----------------------------------------------------
- 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.
-----------------------------------------------------