This article shows how to use the List.Accumulate function in order to create running totals with Power Query.
Πηγή: Creating running totals using the List.Accumulate FunctionThe Ken Puls (Excelguru) Blog
Category Archives: Business intelligence
Filter Arguments in CALCULATE – SQLBI
A filter argument in CALCULATE is always an iterator. Finding the right granularity for it is important to control the result and the performance. This arti
Compare two tables or reports using Power Query – Excel and Power BI
I receive a lot of reports on a daily, weekly or monthly basis. Usually the reports are little changed from the previous version but there is no easy way to work out just what has changed. I susp…
Πηγή: Compare two tables or reports using Power Query – Excel and Power BI
Dynamic TopN & Ranking in Power BI | BI as Business Insight
Proving that what you do has real impact.
Πηγή: Dynamic TopN & Ranking in Power BI | BI as Business Insight
Dynamic Column Selection In Custom Columns In Power BI/Power Query/M – Chris Webb’s BI Blog
When you’re writing an M expression for a custom column in Power BI or Power Query it’s easy to reference the values in other columns. A slightly more difficult question, however, is how can you re…
Πηγή: Dynamic Column Selection In Custom Columns In Power BI/Power Query/M – Chris Webb’s BI Blog
Primary Plotting | R-bloggers
My wife tricked me into a partial-weekend project to try to get all the primary/caucus results to-date on a map (the whole us). This is challenging since not all states use counties as boundaries for aggregate results. I’m still piecing together some shapefiles for the primary/caucus summation boundaries for a couple remaining states but I […]
Hosted Web Apps: Go Beyond the App | Building Apps for Windows
We’ve talked about the right kind of app to start with for a Hosted Web App, and we’ve talked about why Hosted Web Apps are a good approach for a number of media partners. In this post,…
Πηγή: Hosted Web Apps: Go Beyond the App | Building Apps for Windows
Few Steps To Connect R With Excel: XLConnect! | R-bloggers
XLConnect allows to create a formatted spreadsheet usable as a dynamic report of the R analysis. Discover how to link R and Excel with just a few steps The post Few steps to connect R with Excel: XLConnect! appeared first on MilanoR.
Πηγή: Few Steps To Connect R With Excel: XLConnect! | R-bloggers
Ggplot With A Highcharts Taste | R-bloggers
Create maps in R in 10 (fairly) easy steps | Computerworld
Sure you can use this technique for election maps — but it’s also handy for sales figures, mobile data coverage and many other types of data.
Πηγή: Create maps in R in 10 (fairly) easy steps | Computerworld
RSS
SL Galaxy
Facebook
Google+
LinkedIn
Twitter
