Forum Discussion
Oros
Post Prodigy
Post ProdigyDynamic header
Hello, I have a month selector, as well as a 'last x months' parameter selector. How do you show a dynamic title or header based on the selected month and selected last x months? As e...
hi Oros
You will need to use a disconnected table for the count of months to add and the selected months. Below is the sample formula I used to obtain the title in the table in the screenshot
Periods Included = VAR FilteredTable = FILTER ( CALCULATETABLE ( VALUES ( DatesTable[Date] ), DATESINPERIOD ( DatesTable[Date], MAX ( DisconnectedDatesTable[Date] ), - [XPeriod Value], MONTH ) ), DatesTable[Date] = CALCULATE ( EOMONTH ( MAX ( DatesTable[Date] ), -1 ) + 1 ) ) VAR AddedColumns = ADDCOLUMNS ( FilteredTable, "@Month Name", FORMAT ( [Date], "mmm" ) ) RETURN CONCATENATEX ( AddedColumns, [@Month Name], ", ", [Date], ASC )Please see the attached pbix.
danextian
Super User
Super Userhi Oros
You will need to use a disconnected table for the count of months to add and the selected months. Below is the sample formula I used to obtain the title in the table in the screenshot
Periods Included =
VAR FilteredTable =
FILTER (
CALCULATETABLE (
VALUES ( DatesTable[Date] ),
DATESINPERIOD (
DatesTable[Date],
MAX ( DisconnectedDatesTable[Date] ),
- [XPeriod Value],
MONTH
)
),
DatesTable[Date]
= CALCULATE ( EOMONTH ( MAX ( DatesTable[Date] ), -1 ) + 1 )
)
VAR AddedColumns =
ADDCOLUMNS ( FilteredTable, "@Month Name", FORMAT ( [Date], "mmm" ) )
RETURN
CONCATENATEX ( AddedColumns, [@Month Name], ", ", [Date], ASC )
Please see the attached pbix.
