Power BI — Get the Last/Latest Value of a Category
Problem Statement: In the given data filter and show only the most recent row based on date/version etc.
** Don’t forget to check Microsoft Fabric information below
Data: I have taken data where we have ID and date along with status. And we would like to show the latest status.
Solution: We will use a DAX measure for that.
I have loaded the data to the power bi file and created the following DAX measure
DAX Code
Last Status = var _max = maxx(filter(ALLSELECTED(Data), Data[ID] = Max(Data[ID])), Data[Date])
return
CALCULATE(max(Data[Status]), filter((Data) , Data[Date] =_max))You can find the file on Power BI Community. Please like and share.
Refer Video
Microsoft has launched a new generation Data Analytics platform — Microsoft Fabric
The Microsoft Fabric Platform provides customers with a SaaS-ified, open, lake-centric, full-featured data, analytics, and AI platform that meets all of their data Analytics needs.
Microsoft Fabric: New Age Analytics
Microsoft Fabric- What, Why, Who, When, How
Microsoft Fabric: A Brief Introduction
How to enable Microsoft Fabric; on Power BI Service| Start the Fabric (Preview) trial
Microsoft Fabric-What it is, Why Use, Who Should, When and How to use
Microsoft Fabric: Various Components| Microsoft Fabric Create Workspace, Lakehouse, Warehouse
Microsoft Fabric: How to load data in Lakehouse using Dataflow Gen2
Microsoft Fabric: How to load data in Warehouse using Dataflow Gen2
Microsoft Fabric: How to load data in Warehouse using Data Pipeline | End-to-End Scenario
Microsoft Fabric: How to load data in Lakehouse using Spark; Python/Notebook
Microsoft Fabric: Integrated Machine Learning- k-Means clustering
Microsoft Fabric: Create a Date table in Dataflow Gen2, and use in Lakehouse and Warehouse| Time Intelligence with Power BI
Microsoft Fabric: How to load data in Lakehouse using Data Pipeline | End-to-End Scenario
Microsoft Fabric: What are the options to load local files in Lakehouse
Microsoft Fabric: Shortcut with Fabric and for Azure Data Lake | File vs Table Shortcut
Microsoft Fabric: Import Azure SQL Data to Warehouse | Multiple tables using Pipeline
Introduction to Microsoft Fabric in Hindi | What it is, Why to Use, Who Should, When and How to use
Microsoft Fabric in Hindi Part 2: Create Workspace, Lakehouse, Warehouse
To take your data journey to the next level, I’ll be providing more examples in my upcoming blogs and videos.
Complete Power BI in one Video — 11 Hours
Click here to access all my blogs and videos in a jiffy via an exclusive glossary using Power BI. Please like, share, and comment on these blogs. I would appreciate your suggestions for improvement, challenges, and suggestions for topics so that I can explore these in more depth.
In addition, I have over 500 videos on my YouTube channel that are related to Power BI, Tableau, and Incorta. With the help of these videos, you will learn hundreds of DAX and Power Query functions, in addition to hundreds of Power BI, use cases that will assist you in becoming an expert in Power BI. Make sure you subscribe, like, and share it with your friends.
Master Power BI
Expertise in Power BI
Power BI For Tableau User
DAX for SQL Users
Learn SQL
