Forum Discussion
Calculate Correct Tax Rate
Hi Everyone I'm trying to calculate the correct tax rate. Here's the scenario (I have a few screenshots with a small sampling of data). I'm trying to take the LineCost w/o Tax and multiply it b...
grazitti_sapna
Super User
Super UserCorrect Tax Rate=
VAR MAXDATE =
MAX (Schedule[EndDate] )
VAR maxseldate =
CALCULATE ( MAX ( Schedule[EndDate] ), ALLSELECTED ( Schedule[EndDate] ) )
VAR result =
CALCULATE ( MAX ( Schedule[TaxRate] ), Schedule[EndDate] = maxseldate )
RETURN
IF ( MAXDATE = maxseldate, result )