Forum Discussion
data month auery
hiii i have a slicer named month name now i want a line graph displaying past 2 months and current month data based on slicer month name selection. how can i get it https://drive.google.com/file...
Icey
Community Support
Community SupportHola @greeshma ,
Por favor, compruebe:
1. Cree otra tabla Fechas.
Dates =
ADDCOLUMNS (
CALENDAR ( DATE ( 2020, 1, 1 ), DATE ( 2020, 12, 31 ) ),
"Year", YEAR ( [Date] ),
"Month", MONTH ( [Date] ),
"MonthName", FORMAT ( [Date], "mmmm" )
)
2. Cree columnas en la tabla Query.
Call Closed Date = [Call Closed].[Date]
YearMonth = FORMAT([Call Closed Date],"YYYY MMMM")
3. Cree una relación entre las dos tablas.
4. Crear medidas.
M.SLA% 2 = CALCULATE([M.SLA%],DATESINPERIOD ( Dates[Date], MAX ( Dates[Date]), -3 , MONTH ))RAW SLA% 2 = CALCULATE([RAW SLA%],DATESINPERIOD ( Dates[Date], MAX ( Dates[Date]), -3 , MONTH ))Count of Call Closed = CALCULATE(COUNT(Query1[Call Closed]),DATESINPERIOD ( Dates[Date], MAX ( Dates[Date]), -3 , MONTH ))
5. Cree objetos visuales.
Saludos
Icey
Si este post ayuda, entonces considere Aceptarlo como la solución para ayudar a otros miembros a encontrarlo más rápido.
hi icey thank you for the help my issue now is the 3 month trend graph now if i go nd try to place it along with the other graphs displaing only the current month data. the 3 month graph goes it doesnt show any data in the graph.
this graph doesnt shw any data