daxpowerpivot
How can I create a measure that returns the newest status (non-numerical) in the data set?
I have a table in Power Pivot called tabStatus (see picture). I want to create a measure for this table that returns the status_code (a text field) for the newest status (= highest/newest time stamp in the status_change column).
I feel this should be really easy (I am new to DAX). Any ideas as to how I can create this measure?
Appreciate all the help!
Solution
I'm going to assume that your Status_change column is a valid date/time format in your locale.
Newest Status:=CALCULATE(LASTNONBLANK(tabStatus[Status_code],0),filter(tabStatus,max(tabStatus[Status_change])))
- Setting moving default start and end Date in power BI
- How to sort weekdays in Power BI based on today
- Filter multiple visualizations to exclude values that have already been excluded
- How to count direct and indirect test cases for Features, Requirements, and Change Requests in Power BI using DAX?
- Group average as a baseline & individual variance to baseline
- Filtering values on one visual affects filtering on second visual
- Displaying a Fixed Timeline in a Power BI Line and Clustered Column Chart with Slicers
- PowerBi measure where the total is based on the legend and adjusts total for selected slicer
- DAX problem - The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value
- power Bi count the number of completed tasks per bucket
- How would you get category share across time in PBI?
- power query design for performance of queries (using SOAP connector) for Power BI/Excel
- Filtering for all records where date is less than slicer value in Power BI
- Calculate Activity based on logon-logoff times
- dax measure percentage of cost
- What's the difference between DAX and Power Query (or M)?
- Cumulative Sum of Monthly Balance (two tables)
- Power BI: add slicer value into table
- DataFormat.Error: We couldn't parse the input provided as a Date value
- How to use ORDER BY in Power BI DAX
- Using OFFSET to get the value from a previous row so that I can calculate the difference
- Power BI table shows one of the column values in the total instead of the column sum
- Get Average of Top 3 in a Summarized Table in Power Bi
- TOTAL is correct but rows are missing
- Dax - how to get average value per day where column x value is y?
- Fixed values but variable year
- Power bi desktop table visual out of memory on a simple DAX
- Use DAX Query to create table in Power BI
- Subtraction of previous period in PowerQuery
- Dynamically changing the band based on aggregate chosen from slicer