Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
vMaxCurrentDateLY=maxstring(Date-365)
vMaxFinYear_1=$(vMaxFinYear)-1
Any ideas on what is going wrong??