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
JChouris
Helper I
Helper I

Turning Individual Years into a Span of Time

I am trying to take an excel sheet of data with Make, Model, and Year for vehicles into a BI Report. I need to take the individual years like 1998, 1999, 2000 and turn them into a value like 1998-2000. I am newer to BI and unsure how to do this. Any Help would be greatly appreciated.

JChouris_0-1690379249512.png

 

1 REPLY 1
DataVitalizer
Super User
Super User

Hi @JChouris 

You can create a grouping field, please check this link

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning

 


Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.