Calculation revenue for the last date
Hi, I am a bit lost concerning the use of MAX with dates. I thought it would be possible to use a dynamic max date and then combine it with a calculate revenue function. Here is my issue: I need a measure that takes into account only the freshest date in my data set. So in this case, for project release it needs to return only the revenue for the 2nd of December 2020. But filtering my revenue with the max date delivers an error. I am still new at DAX and getting confused by all the possibilities. How should I approach this? Thanks! Pauline.How to get revenue for the last date in month
Hi, I need to write a measure for revenue based on a changing max date. This is the problem: in my raw data, I get the date for each stage change, meaning that one order will have for example 3 milestones with a different date and revenue associated. I need to report the revenue for the latest change within a milestones and a month and ignore all other revenue information. Let's say I have only one order to consider. Left is what I get as raw data from my databank, right is what I need to report: Is there anyway to define the revenue per milestone and link the max date information with a slicer (=showing up the last day of each month for the report to automatically adapt)? Any help for this will be really appreciated! Thanks, Pauline.Get the max value per date based in serial
I have 3 fields Serial, Date and Temp. The date field is actually a date time field I converted to just a date. I am trying to get the max Temp per date for each serial number. In the past I have done this to get the max date of each serial and filter on only the columns with 1. Max Date = IF('Export'[datetime]=CALCULATE(MAX('Export'[datetime]),ALLEXCEPT('Export','Export'[serialnumber])),1,0) The complexity here is adding the Temp. I need to flag each row somehow that this is the max temp for that serial on that day. Here is a sample of what I am trying to do. I dont necessarly need a max temp column with 1,0 but that how I was able to do it before.
