MAXDate and Maxdate)lastyear with value
Hi, I am trying to make a KPI card which shows how much we invoiced today and sameday last year. This it works. (see measure below). As you can see below this is what the KPI looks like. Right now same day last year shows blank as last year, now this day was weekend(see day 8 in example below) . However I want it to show 90 since its the max day last year that had a value (I dont want to show later than 2023-05-08) IRevenue MAX (This Year) = CALCULATE([Revenue],FILTER(calendar,calendar[invoice_date]=(max(calendar[invoice_date])))) IRevenue MAX (Last Year) = CALCULATE([Revenue],FILTER(calendar,calendar[invoice_date]=(max(calendar[invoice_date])-365))) Thanks in advance!
Filtering for most recent date in a group
Hello, I'm trying to only show the line that has the most recent RoleLastUpdate (see Image) for each distinct RoleID.. I've tried this solution, however this only shows the most recent date for the whole table. Solved: Filtering table for rows showing the max date per ... - Microsoft Fabric Community This solution is supposed to put a '1' next to the latest date, which can then be filtered on, however it's putting a one next to every date (image - last column). I've checked the example from the solution and mine looks the same, aside from the table/column names. Solved: How to Filter a Table To Show Only Most Recent Dat... - Microsoft Fabric Community The only filter I have on is for specific users, which shouldn't effect results as they're grouped by RoleID, and in this case the same user is attached to each. DAX used. MostRecentUpdateFilter2.0 = VAR maxdate = CALCULATE( MAX ('Legal IR35RoleReview'[RoleLastUpdate]), ALLSELECTED ('Legal IR35RoleReview'), VALUES ('Legal IR35RoleReview'[RoleID]) ) RETURN IF(MAX('Legal IR35RoleReview'[RoleLastUpdate]) = maxdate, 1, BLANK() ) Can anyone see where it's going wrong? Thanks.
