Identify latest result and count
What DAX, or combination of DAX, do I need to use to achieve the following please: I have a data source (excel based rn) which lists a project reference number, the date and the RAG status of that project. This data source is going to grow as each new months status updates are gathered together and added to the list. What I would like to do is have a measure for each RAG outcome which tots up the latest update - whether that's all the most recent months entries or from months ago (it could be that there are no updates for a few months on the trot). Data is organised in columns with reference numbers, date of update and RAG outcome (red, amber or green). In a matrix this looks like this: And you can see how some references have an updated RAG for every month, some have gaps and some have none. How do I count the most recent RAG statuses only (regardless of whether june or april for example), one time for each reference number only and for each RAG (3 sep measures)..?? I've tried other solutions to similar queries but relicating them hasn't worked and only given me the single most recent result.
Get latest value from other table that contains blank value
Hi, I need to return the latest value based on date of the entry. Table "Scoring Entry" consist of blank values and each test was submitted on different date and for different students. How am i supposed to get a table that looks like Table "Latest Scoring" that return only the latest scores for each students? I tried using FILTER, SUMMARIZE and LASTNONBLANKVALUE functions but that only return the result of MAX/MIN value of the scoring. Much Appreciated 🙂Fill Blanks with latest if based on sequence
Hello there, I'm having some trouble on solving this one. To give a breif example, we have a sequence from 1 - 5 each with a status and date. Sometimes the user skips this sequence and now I'd like to fill the gap with the latest date available. Example ID Status StatusID LatestDate 025755 Intial Lead 1 Jan 1 2021 025755 Regular Lead 2 Jan 5 2021 025755 Hot Lead 3 To be filled 025755 Signature Pending 4 To be filled 025755 Success 5 Jan 25 2021 Example2 ID Status StatusID LatestDate 025755 Intial Lead 1 Jan 1 2021 025755 Regular Lead 2 To be filled 025755 Hot Lead 3 14 Jan 2021 025755 Signature Pending 4 025755 Success 5 Now as you can see we have 2 statuses in example 1 that were skipped and thus have no dates. My objective is to fill these blank spaces for each group(ID) with the latest date available based on the max status/statusID. In example 2, 1 status was skipped and the latest current Id is 3, so we only need to fill the one in between. By default, status(ID) 1 always has a date. Thanks!
DAX formula for latest month based on selected filters
Hi, I am trying to get the duration minutes for the lastest month of the selected months in a slicer. In case none is selected then it should consider the latest month/max. Currently I have the formula below, but it is clearly not working. Also DOWNTIME[MONTH] is a numeric field (1,2,3,...,12), so I would probably have to convert D_Calendar[Month] before evaluating. mDurationLatestSelectedMonths(min) = CALCULATE(sum(DOWNTIME[Duration Minutes]),KEEPFILTERS(DOWNTIME[MONTH]=VALUES(D_Calendar[Month]))) Thank you. Best regards, André
Data to show by Latest date by default in Report server
Hi Users, I am able to show the report by latest date using the relative filtering option but i have a problem when the data refreshes on the report server on a daily schedule. Currently when the data refreshes on the report server using the schedule refresh the Date slicer fails to show the latest date by default. So now every time i have to refresh the report on desktop and upload the latest version to server. So my question is there a way where the date is defaulted to current date every time report refreshes in the date slicer as below by default? And then the user can customize the time period they would need . Also, i created a Istoday column to achieve this as below but it seems that when i use that column it doesnot give the between option to select date range and just gives the List and Dropdown option, so could not use this column. Istoday = SWITCH( TRUE (), 'Calendar'[Date] =UTCTODAY(), "Today", FORMAT('Calendar'[Date],"MM/DD/YYYY"))
