PowerBI "Select Group By" on exsisting table


Sometimes we need to calculate things different. Gere you will find an example for takeing over an exsisting table we already imported to PBI. and then as the 2nd step we need to calculate sum with group by. This is the base script:   Recodings Per Month = SUMMARIZE ( 'Invoice Line Item', ('Invoice' ), 'Item', "Recording ", SUM ( 'Invoice Line Item' ) ,"yyyymm", left('Invoice' ,6) )   attached you will find a PBIX sample
תגיות: ,
אין תגובות

PowerBI 2017/05 Licensing manual


3 levels of license: Free – No Sharing and cannot be shared with Pro – Both Author and End users need a license Premium – Report Authors must have Pro, End Users are free   More FAQs with a whole slew of Q&A are on the Power BI Community Site. http://community.powerbi.com/t5/Changes-to-the-free-Power-BI/May-3-announcement-overview/m-p/167395#M4 http://community.powerbi.com/t5/Changes-to-the-free-Power-BI/May-3-announcement-FAQ/m-p/169043#M80

SQL Saturday 27-4-2017


I also submitted 4 session hope to Presenting: Regular Session (60 minutes): Sql Server 2016 Tabular Architecture. Living On the Edge. (BI Platform Architecture, Development & Administration) Submitted: Regular Session (60 minutes): The BIG Data of your Things (Strategy and Architecture) Data Modelling Starting KIT For Beginners (BI Platform Architecture, Development & Administration) Solid Architecture for a Solid BI Model. Much more than Best Practice. (BI Platform Architecture, Development & Administration) IOT. Do not even think to blink. (BI Information Delivery)
תגובה אחת

Sql Server 2016 Tabular Architecture. Living On the Edge.

Sql Server 2016 Tabular Architecture. Living On the Edge. Join My session on Sql 2016 Extreme BI. It will take place on 2017 APR 27. http://www.sqlsaturday.com/623/Sessions/Details.aspx?sid=59671   This session will do a brief overview of Tabular Mode 2016 performance topics, and drill into some common methods for investigating performance issues. Tabular performance and monitoring with Activity Viewer 2016 ( http://activityviewer2016.codeplex.com/releases) Performance investigation tools: Profiler, XEvents, MDX, ETW Tuning Tabular Mode for high end hardware Common pitfalls for processing performance Formula engine performance. Tabular Development LifeCycle Best Practice and +++
אין תגובות

Sql 2014 sp2 cu 4


This CU will be available for download from Download Center. The associated cumulative KB article,KB4013103, has also been published. Customers are directed to obtain the hotfix package through the new self-service feature by clicking on the Hotfix Download link found at the top of the KB article.
אין תגובות

Azure Machine learning


If you are looking for Azure macine learning, you call the team at SolidBI.com ( aml@solidbi.com  aml@solidbi.com ) or you can have a look on edx.org https://www.edx.org/course?search_query=azure+machine+learning or Microsoft Virtual Academy https://mva.microsoft.com/en-US/training-courses/data-science-and-machine-learning-essentials-14100?l=UyhoTxWdB_3505050723
תגיות: ,
אין תגובות