Forum Discussion
sanimesa
Post Prodigy
Post ProdigyFIRSTDATE and LASTDATE functions broken?
Has anything changed with the Firstdate and Lastdate functions in the May release? I have a date slicer with the invoice date added to it. To display the slicer selection, I use the below meas...
Sometimes FIRSTDATE and LASTDATE will appear to "work" on non-contiguous non-unique date columns if the dates selected just happen to lack overlaps that affect the calculation, or in some cases the error is small enough that you won't notice it. The fact that you've used them in the past just means you accidentally got away with it, not that it was the correct way to use them.
Now, if you were to connect all of this to a date dimension and point those FIRSTDATE and LASTDATE formulas at that table's date column with a relationship to this table's date column, they should work as expected. If you want to stick with the table structure you're already using, use some variation of MIN/MAX/MINX/MAXX instead.
mohittimpus
Helper V
Helper V#Confidence Range = CALCULATE(SELECTEDVALUE(MLPredictionsX[Confidence Range net]),LASTDATE(MLlnput[ProdDate]))
In this I am not used the Min and Max in place of LastDate