skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Office 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Overview
    • Find consulting services
    • Partner showcase
    • Find a partner
    • Become a partner
    • Instructor-led training
    • Getting started
      • Overview
      • Online workshops
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Events
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power BI Community
    • Galleries
    • Quick Measures Gallery
    • Firstnonblankvalue and Lastnonblankvalue

    Firstnonblankvalue and Lastnonblankvalue

    07-13-2020 05:01 AM - last edited 07-13-2020 05:39 AM

    Super User amitchandak
    Super User
    3316 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    amitchandak
    Super User amitchandak
    Super User
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    Firstnonblankvalue and Lastnonblankvalue

    ‎07-13-2020 05:01 AM

    Firstnonblankvalue and Lastnonblankvalue release some time back. But they remained underutilized. They are very powerful in terms of finding the first and last values.

     

    Say, For the customer, we wanted to know First Sales Dates, Sales Amount of first sales date. Firstnonblankvalue makes it easy.

    Or, For the customer, we wanted to know the Last Sales Dates, Sales Amount of Last sales date. Lastnonblankvalue makes it easy. 

     

    You can use row context for correct grand total or more complex calculations. Or use one inside other for more such cases.

     

     

    For First date and Last date you can also use Firstnonblank and Lastnonblank, but for sales you have to use Firstnonblankvalue and Lastnonblankvalue

    eyJrIjoiNDgxYzVhOGUtMzdlZi00MDkzLWI4NjAtZjAwY2IwM2QwYTdkIiwidCI6ImVhOGJkMWZkLWFjMzQtNGFlMi1iNDIxLTZjZmEyZmNmZjI0MyJ9



    Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
    Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s
    Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
    Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
    Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!
    firstAndLastNonBlankValues.pbix
    Labels:
    • Labels:
    • Filters
    • Other
    Message 1 of 1
    3,316 Views
    8
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Partners
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    © 2022 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks