Forum Discussion
Helper I12 Months Trailing graph using custom Calendar
Helper IHere is the PBIX file shared from OneDrive > https://1drv.ms/u/s!Ao4G1JQhVsM1ki3KNfhdNnpE49cW
Hi Landcrab ,
I checked the pbix file. By putting [ACIDTestRatio] as column values in the bar graph the values are the same.
Can you explain what you want achieve in [AcidTestRatioDisconected]. Is this measure different from the ACIDTestRatio.
Cheers
CheenuSing
- Landcrab
Hi Anonymous ,
Thank you for having a look at it.
The PBIX file has been updated to try and simplify the question and here is hopefully a better explanation of what we are trying to acheive.
https://1drv.ms/u/s!Ao4G1JQhVsM1ki5CKnWXem3Hzo48
Our question is how to return only the last 12 months from the slicer/ CurrentDate/ PreviousDate in the CalculationResult in [ACID TEST Ratio Disconnected]??
At present, if a single Financial Year (FY) is selected this occurs, BUT, as soon as we choose a date where the PreviousDate is in a previous FY the calculation result returns data from the Start of previous FY to the end of the FY coorsponsding to the selected date which is wrong.
Note - this is a week based calendar, which means inbuilt functions such as TOTALYTD do NOT work for calculations we want to do.
See [YTD Actual] and [Total Movement Actual] measures for our implementation of YTD.
The 'Gl Balances'[PeriodMovement] are summable only within the same financial year. This is because 'Period 1' contains an Opening Balance.
The VARs used in [ACID Test Ratio Disconnected] have been repeated in a seperate measure called [ALL VARs]
and is shown in concatenated card visual on the page, so we know what values we are working with.
If only we can get at the Column name of the variable we could filter it between Current and Previous dates, otherwise blank.
Any help is greatly appreciated.