Power BI DAX using Index - December 2022

Ranjan Das Ranjan Das

Ranjan Das

Power BI Architect / Product Manager @ SymphonyAI | Microsoft Fabric | AI

发布日期: 2023年1月18日
+ 关注
Second cheapest Price and Second Most Expensive Price
Second Cheapest Price and Second Most Expensive Price

  1. SecondCheapestPrice = Index(2, ALL('Product'[Price]))
  2. SecondMostExpensivePrice = Index(-2, ALL('Product'[Price]))

要查看或添加评论，请登录

Ranjan Das的更多文章

  • Power BI & Microsoft Fabric
    2024年10月22日

    Power BI & Microsoft Fabric

    Power BI and Microsoft Fabric are both tools within the Microsoft ecosystem, but they serve different purposes and are…

  • Refresh power bi Huge dataset in Power bi service not in Desktop.
    2022年4月23日

    Refresh power bi Huge dataset in Power bi service not in Desktop.

    Refresh power bi Huge dataset in Power bi service not in Desktop. 1st develop report pointing to Development…

  • Power BI Workspace
    2022年4月23日

    Power BI Workspace

    Upgraded workspace: When creating workspace automatically (Default) creating an "upgraded workspace" and Specifying…

  • Power BI Free License Offer you
    2022年3月15日

    Power BI Free License Offer you

    You can connect and import data from over 70 cloud-based and on-premises sources. Auto-detect that finds and creates…

  • Import & Direct Query in Power BI
    2022年3月9日

    Import & Direct Query in Power BI

  • Tableau LOD & Power BI DAX
    2022年3月7日

    Tableau LOD & Power BI DAX

    Tableau LOD to Power BI DAX or Power BI DAX to Tableau LOD. Tableau : {FIXED : MAX([Sales] )} Power BI :…

社区洞察

其他会员也浏览了