cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Convert sql to M

Hello All,

 

How do I write below sql into M query:

 

select sum(Sales) over (aprtiton by Country, State) from emp;

 

select count  (empid) over() from emp2;

 

Thanks,

Aditya

4 REPLIES 4
JosefPrakljacic
Solution Sage
Solution Sage

Hey @Anonymous ,

 

I would rather do this. And it would be better to do it like this according to this link.

 

image_thumb6.png

 

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Have a nice day!

BR,
Josef

Anonymous
Not applicable

NO, I would like to know how this works

I need to apologize @Anonymous 

 

I thought you wanted to have the optimal solution to your problem.

 

But if you want to know how to do this technically, then I can refer you to this link.

 

The principle is the same as yours.

 

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Have a nice day!

BR,
Josef

Anonymous
Not applicable

In the example shown it is a Row number, I need a sum

(Sum of the entire column, Example:  sum(sales) Over( order  by  year) 

 

, I have tried it but unable t get it. Can you please show through an example 

 

@Greg_Deckler 

 

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors