Thanks a lot for all such wonder videos on Power BI. You truly are following that saying "The more knowledge you share, the more knowledge you gain" ..... Please keep doing this great work. 👍
This worked great thanks. In my case the P&L had another tier of categories (eg. revenue > contract revenue > school contracts) and a lot of lines in the 3rd tier (250) so I did greater than/less than the row id number rather than naming the row numbers individually.
Many many thanks 🙏 Hope you will like the other video and the blog too Power BI How to get two columns format Profit and Loss Statement(P&L) right: ruclips.net/video/WLg85yiMgHI/видео.html medium.com/microsoft-power-bi/power-bi-formatted-p-l-with-custom-sub-totals-and-blank-rows-e39ca822908a Also, check out Expertise Power BI: ruclips.net/video/59PUFuuCrbY/видео.html Mastering Microsoft Fabric 35+ Videos: ruclips.net/video/p-v0I5S-ybs/видео.html
Hi Amit, Thanks for the tutorial. I am wondering I have received this error message when trying to sort the "Account" by "Order_id" : We can't sort the account column by order_id. there cant be more than one value in order_id for the same value in account. Please choose a different column for sorting or update the data in order_id. Appreciate if you can provide some guidance. Thanks!
For that, what I have done, I first created a file where there was one to one mapping of account, without blank accounts, and later added those in next refresh.
Source File: github.com/amitchandakpbi/powerbi/blob/main/P%26L%20Data.xlsx
Pbix: github.com/amitchandakpbi/powerbi/blob/main/P%26L%20Final%20for%20Git.pbix
Thanks a lot for all such wonder videos on Power BI. You truly are following that saying "The more knowledge you share, the more knowledge you gain" ..... Please keep doing this great work. 👍
So nice of you, and I agree, sharing is the best way to gain knowledge. Thank you for your appreciation. It motivates me to keep going.
Watch the next video- Power BI create two columns format Profit and Loss Statement: ruclips.net/video/WLg85yiMgHI/видео.html
This worked great thanks. In my case the P&L had another tier of categories (eg. revenue > contract revenue > school contracts) and a lot of lines in the 3rd tier (250) so I did greater than/less than the row id number rather than naming the row numbers individually.
Thanks for sharing for great stuff u r really great teacher.... kindly make another video about cash flow statement
Thanks. I'll look into that. Check out the new video on the same subject- ruclips.net/video/WLg85yiMgHI/видео.html
excellent
Many many thanks 🙏
Hope you will like the other video and the blog too
Power BI How to get two columns format Profit and Loss Statement(P&L) right: ruclips.net/video/WLg85yiMgHI/видео.html
medium.com/microsoft-power-bi/power-bi-formatted-p-l-with-custom-sub-totals-and-blank-rows-e39ca822908a
Also, check out
Expertise Power BI: ruclips.net/video/59PUFuuCrbY/видео.html
Mastering Microsoft Fabric 35+ Videos: ruclips.net/video/p-v0I5S-ybs/видео.html
Hi Amit, Thanks for the tutorial. I am wondering I have received this error message when trying to sort the "Account" by "Order_id" : We can't sort the account column by order_id. there cant be more than one value in order_id for the same value in account. Please choose a different column for sorting or update the data in order_id. Appreciate if you can provide some guidance. Thanks!
For that, what I have done, I first created a file where there was one to one mapping of account,
without blank accounts, and later added those in next refresh.
@@AmitChandak Thanks, i have found the way.