Skip to content

zahid's BI blog

a showcase of my experience in technologies like SQL, SSAS, ETLs, Azure, Power BI, DAX etc..

  • Home
  • About..
  • Data Visualization Screenshots

Tag: common maximum

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

  • 194,893 hits

Recent Posts

  • Finding common maximum in Power BI
  • Links in Power BI
  • Non-additive measures with different granularity in Power BI
  • Restore SQL Server database using SAS from Azure Blob Storage
  • Device specific logic in Microstrategy

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 2 (using dts variable)
  • Finding common maximum in Power BI
  • Dynamic Column Mapping in SSIS : Part 1
  • Non-additive measures with different granularity in Power BI

Categories

  • Azure
  • Data Quality Service (DQS)
  • MDS (SQL Server Master Data Service)
  • MDX, SSAS (Analysis Service), Cube
  • Microstrategy, MSTR
  • 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 22 other followers

Create a free website or blog at WordPress.com.
Cancel
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