I am trying to write a measure to solve for a paycheck amount given a YTD paycheck amount and paycheck date. Note, this will be run on a very large database so I am trying to avoid using any calculated columns. Here is a sample table of data: The following measure returns the error...
YTD return refers to the amount ofprofitthat's made by an investment since the first day of the current year. Investors and analysts use YTD return information to assess the performance of investments and portfolios. Calculate a YTDreturn on investmentby subtracting its value on the first day o...