changing data
1 Topic
Grouped by time to maturity with between slicer
Hi all, I have a table which requires me to group by time to maturity. This is done directly in Power Query where the "TimeToMaturity" is calculated by subtracting "As Of Date" with "MaturityDate". After this I have grouped them by adding a column named "MaturityBucketName" and "MaturityBucketID" with an if statement based on the column "TimeToMaturity" in the following categories: MaturityBucketName MaturityBucketID Under 2.25 years to maturity 1 Between 2.25 and 3.25 years to maturity 2 Above 3.25 years to maturity 3 In my report all contracts is then grouped by these in a matrix, which consists of the following rows: MaturityBucketName ContractID Then on the same page I have some other timeseries data, which is calculated using a between slicer, which also affects my ContractIDs as when they change groups in my grouping data, they are getting duplicated, so the same contract is now both in i.e. Between 2.25 and 3.25 years to maturity and under 2.25 years to maturity. Does anyone know how to solve this issue, I have tried generating this in DAX with a max function on date, but it does not allow me to apply it on the row level? Best Regards.Solved731Views1like2Comments