Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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/d/16YSO8dxe8KkxL4Av6vHlSSIfHdVhQZvH/view?usp=sharing

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

Hello @greeshma ,

Change the slicer field to "MonthName" in the "Dates" table.

slicer.JPG

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

View solution in original post

5 REPLIES 5
Icey
Community Support
Community Support

Hi @Anonymous ,

 

Please check:

 

1. Create another Dates table.

 

Dates =
ADDCOLUMNS (
    CALENDAR ( DATE ( 2020, 1, 1 ), DATE ( 2020, 12, 31 ) ),
    "Year", YEAR ( [Date] ),
    "Month", MONTH ( [Date] ),
    "MonthName", FORMAT ( [Date], "mmmm" )
)

 

 

2. Create columns in your Query table.

 

Call Closed Date = [Call Closed].[Date]

 

date.JPG

 

YearMonth = FORMAT([Call Closed Date],"YYYY MMMM")

 

 

3. Create relationship between the two tables.

relationship.jpg

 

4. Create measures.

 

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. Create visuals.

visuals2.JPGvisuals1.JPG

 

 

 

Best regards

Icey

 

If this post helps,then consider Accepting it as the solution to help other members find it faster.

Anonymous
Not applicable

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

greeshma_0-1603820920147.png

Icey
Community Support
Community Support

Hello @greeshma ,

Change the slicer field to "MonthName" in the "Dates" table.

slicer.JPG

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

camargos88
Community Champion
Community Champion

@Anonymous ,

 

I see you have some date column, which date column can you use as reference for the month name ? So we can create a measure to achieve what you want.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Anonymous
Not applicable

i have used call closed date table

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.