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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
fabiomanniti
Helper III
Helper III

Filter until date: month by month

I want to make a "month by month" filter but if I use the date hierarchy I can see the situation only in that month and not until that month.

I can use a date filter using "Before" but in this way I can discretize only day by day and not month my month.

 

I'll explain better:
I want to know who sold more product so far: I make a chart ordering by "Product sales" and I take the first one.

If I want to know who was the first last month I can use this filter 

fabiomanniti_0-1643195508988.png

 

and I see what happened until the selected date.

 

This works but I don't like because it goes day by day and I would like it month by month.

How can it be possible?

Thank you

1 ACCEPTED SOLUTION
1 REPLY 1
amitchandak
Super User
Super User

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.