THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Excel   (RSS)
Showing page 1 of 6 (57 total posts)
  • Apply AND instead of OR logic to multiple selection in a slicer #dax #powerpivot #powerbi

    I recently write a small article on SQLBI to describe how to create a DAX measure that search for items that have all the items selected in a slicer, instead of any of them. For example, you might want to create a measure that display how many customers bought at least one product for each of the categories selected in a slicer. You cannot ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 17, 2015
  • Derive fiscal week using Excel

    I had to do something in Excel today that might be useful to other folks so sharing it here. I've got a A4 sheet sellotaped to my desk that tells me the start and end date of each fiscal week in our fiscal year. Its useful but its only for 2015 and moreover I could do with the information in digital form rather than dead tree form. I figured I ...
    Posted to Jamie Thomson (Weblog) by jamiet on September 16, 2015
  • Power BI Desktop & Excel

    The August 2015 update of Power BI Desktop added two important features for existing Excel and Analysis Services users:Import Excel Power BI artifacts (Data Model, Queries, Power View) into a new Power BI Desktop fileLive Analysis Services Connections: Ability to change the database from Edit Queries dialogIn case you didn't try it before, ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 31, 2015
  • DAX Studio 2.2 released - tracing support for #powerpivot and much else! #dax

    Thanks to Darren Gosbell we have DAX Studio 2.2. In this new release:Tracing (query plans and server timings) available for Power PivotBasic implementation of IntellisenseConnect to Multidimensional SSAS serversSupport for multiple Power BI Desginer instancesHighlight unnatural hierarchies (read here why this is so important for ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on June 24, 2015
  • Issues with July 2014 Office Update and Click-to-Run #excel #powerbi

    An interesting experience with Office Click-to-Run is that trusting it to install updates the night before a conference where you are a speaker. I’m writing this blog post while Alberto Ferrari is delivering its part of the preconference training day at SQL Bits about how to create a complete solution in Power BI. But I think it’s important to ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 17, 2014
  • Calculate New, Returning, Lost, and Recovered Customers in #dax

    Calculating the number of new and returning customers is a recurring question. I would say this is a “classical” Business Intelligence problem, very common in marketing department. I worked on these problems with many customers, with small and large datasets, and I wrote a DAX Pattern “New and Returning Customers” showing how to calculate: New ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on June 26, 2014
  • Tips for adapting Date table to Power View forecasting #powerview #powerbi

    During the keynote of the PASS Business Analytics Conference, Amir Netz presented the new forecasting capabilities in Power View for Office 365. I immediately tried the new feature (which was immediately available, a welcome surprise in a Microsoft announcement for a new release) and I had several issues trying to use existing data models. The ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 20, 2014
  • Create Excel Dashboards working on Excel for iPad #excel #ipad #dashboard

    I recently tried Excel for iPad and tried opening several workbooks. The results are pretty good, but I’ve found that it wasn’t possible to display certain workbooks. For example, opening a workbook that contains many CUBEVALUE formulas, I should have seen this result: However, sometime I’ve got an error saying that the workbook cannot be ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 15, 2014
  • OneNote API – finally! Now, about that Excel API…

    I’m a frequent user of OneNote and so was delighted with today’s news that there is now a public API available so that third party apps and services can put stuff into your OneNote notebooks (an API? welcome to the modern web, OneNote). One of those third party services is ifttt so I’ve set up a few ifttt recipes to dump stuff into OneNote: ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 17, 2014
  • Connecting to #powerpivot from an external program (such as #Tableau)

    Many people requested me how to connect to Power Pivot from an external program, without publishing the workbook on SharePoint or on Analysis Services Tabular. I always said it is not possible (for both technical and licensing reasons), but someone observed that Tableau is able to extract data from a Power Pivot data model connecting directly to ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 26, 2014
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement