cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Impactful Individual
Impactful Individual

How to create many row expression ?

Hi All

When i enter syntax to PBI , i can only type in one row :-

average = (sum('Table'[Current Month - 1])+sum('Table'[Current Month - 2]))/2
 
May i know how to type in multiple row :-
average = (
sum('Table'[Current Month - 1])+
sum('Table'[Current Month - 2]))/2
 

Paulyeo11_0-1605773535956.png

 

 

1 ACCEPTED SOLUTION
Super User I
Super User I

@Paulyeo11 , Use SHIFT+ENTER to write in a new line. 





If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




View solution in original post

4 REPLIES 4
Super User I
Super User I

@Paulyeo11 , Use SHIFT+ENTER to write in a new line. 





If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




View solution in original post

Hi All

Thank you very much

Paul

Super User II
Super User II

@Paulyeo11 Use Shift+Enter , which breaks the line, to type the formula in the way you want.


Nikhil
Hit the Thumbs-up button if you find this informative!!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!

Resolver III
Resolver III

Use shift enter if you want to start a new line

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

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

Top Solution Authors
Top Kudoed Authors