Forum Discussion
Dynamically get top 12 time periods when switching between date field parameters
All - I am trying to show the most recent twelve date results for each selection "Year", "Quarter and Year", and "Month and Year" which are field parameters from my date table 'date'. Date T...
Would you mind sharing a pbix file with some sample data?
I want bottom right graph to look like other three when you switch between dates. (top 12 for each)
All I have for my fact table columns is uniuqe ID, volume amount, volume date.
I show DAX for data table, volume, and field parameters below.
My date table :
Date Table is the following:
Date =
VAR Days = CALENDAR(min(test[PIF Date]),max(test[PIF Date]))
RETURN ADDCOLUMNS (
Days,
"Year", YEAR ( [Date] ),
"Month", FORMAT ( [Date], "mmmm" ),
"Month Number", MONTH([Date]),
"Start of the Month", DATE( YEAR([Date]), MONTH([Date]),1),
"End of the Month", EOMONTH([Date],0),
"Quarter and Year", "Q"&FORMAT([Date],"Q YYYY"),
"Month and Year", FORMAT([Date],"MMM YYYY")
)
My volume calculation is :
Volume = CALCULATE(SUM(test[Volume]), USERELATIONSHIP(test[Date],'Date'[Date]))
Field parameter:
Parameter = {
("Year", NAMEOF('Date'[Year]), 0),
("Quarter and Year", NAMEOF('Date'[Quarter and Year]), 1),
("Month and Year", NAMEOF('Date'[Month and Year]), 2)
}