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: dax treatas

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,891 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
  • Non-additive measures with different granularity in Power BI
  • Dynamic Column Mapping in SSIS : Part 1

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

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