Past Financial Year To date with variables

ChiCho — Thu, 27 May 2021 12:37:04 GMT

Hi All,

I am trying to create a previous year to date for the last financial year. The financial year runs from March to February.

I am currently using the below for my Year To Date which works perfectly

sum({<DataType={'Transaction'},FinYear={$(vMaxFinYear)},[Transaction Date]={"<=$(vMaxCurrentDate)"}>}[Meter Count])

Variables are as follows,

vMaxCurrentDate=maxstring(Date)

vMaxFinYear=max(FinYear)

Then for my previous financial year to date I am using the following,

sum({<DataType={'Transaction'},FinYear={$(vMaxFinYear_1)},[Transaction Date]={"<=$(vMaxCurrentDateLY)"}>}[Meter Count])

Variables are as follows,

vMaxCurrentDateLY=maxstring(Date-365)

vMaxFinYear_1=$(vMaxFinYear)-1

Any ideas on what is going wrong??

topic Past Financial Year To date with variables in App Development