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

Try your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now

Reply
Anonymous
Not applicable

Time functions

Hi,
@amitchandak , @Ahmedx 
I have data in which I have to get the data for the last month and the month before that based on the month and year that I am selecting using slicer. I dont want to use any calendar table here
i.e.., If I am selecting may then I need to get the data for april and march 
not sure how to get this done.

Appreciated your support.

Thanks,

2 REPLIES 2
Anonymous
Not applicable

By changing the month in the slicer I need the details of flights, inbound and outbound for the last month and the month before that 

Nagendrasai_0-1685504401278.png

 

Ahmedx
Super User
Super User

Can you please share your demo input and expected output!

Helpful resources

Announcements
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.