Skip to content

Zahid's blog on Data Engineering and BI

A showcase of my experience in technologies like SQL, SSIS, SSAS, ETL, Azure, Power BI, DAX etc..

  • Home
  • About..

Tag: Power BI calculated column

Finding common maximum in Power BI

January 15, 2020

Let’s get straight into the problems. Problem #1 You get country sales data on monthly basis. But, some of the countries i.e. Switzerland and Italy lag the others. Let’s imagine a scenario when all countries latest data (June-2020) has arrived except Switzerland and Italy. This is how your data table would look like in this … More Finding common maximum in Power BI

Leave a comment Finding common maximum in Power BI

Blog Stats

  • 223,492 hits

Recent Posts

  • Oracle Wallet based connection with Power BI
  • Sync Azure Analysis Service Replicas with Azure Automation
  • Analysis Service – current context is read-only
  • MongoDB – where to start
  • Cascading or parent-child slicer issue in Power BI

Top Posts & Pages

  • MAT (Moving Annual Total), YTD (Year to date) calculation using BottomCount, Tail, Properties function in MDX
  • Dynamic Column Mapping in SSIS : Part 1
  • Cascading or parent-child slicer issue in Power BI
  • Dynamic Column Mapping in SSIS : Part 2 (using dts variable)
  • Sync Azure Analysis Service Replicas with Azure Automation

Categories

  • Azure
  • Data Quality Service (DQS)
  • MDS (SQL Server Master Data Service)
  • MDX, SSAS (Analysis Service), Cube
  • Microstrategy, MSTR
  • MongoDB, NoSQL
  • MS Visual Studio, C#.NET
  • Power BI, DAX
  • Spark, Python
  • SQA, Testing
  • SQL, Database
  • SSIS (SQL Server Integration Service)

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 23 other subscribers
Create a free website or blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • Zahid's blog on Data Engineering and BI
    • Already have a WordPress.com account? Log in now.
    • Zahid's blog on Data Engineering and BI
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...