Forum Discussion
AjithReddy049
3 years agoFrequent Visitor
matrix Column headers Order Handling
Hi Team, I have some requirements like. in a matrix visual would like to show the latest 3 months' column headers like Sep-2023, Oct-2030, and Nov-2023 in the current year, and the remaining...
- Anonymous3 years ago
Hi AjithReddy049 ,
I created your sample pbix file(see the attachment), please check if that is what you want. Please create a calculated column as below and put it on the Columns Field of matrix just like below screenshot...
Column = VAR _maxdate = CALCULATE ( MAX ( 'Query1'[DueDate] ), ALL ( 'Query1' ) ) VAR _mindate = EOMONTH ( _maxdate, -3 ) + 1 VAR _mindyear = YEAR ( _mindate ) VAR _dyear = YEAR ( Query1[DueDate] ) RETURN IF ( 'Query1'[DueDate] >= _mindate && 'Query1'[DueDate] <= _maxdate, 'Query1'[Format], IF ( _dyear = _mindyear, "Remaining Months - " & _mindyear, "FY-" & RIGHT ( _dyear, 2 ) ) )Best Regards
AjithReddy049
3 years agoFrequent Visitor
thanks for the response.
Could you please elaborate above measure, [FY] is it a measure? if measure what I need to aggregate?