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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sandierea
Frequent Visitor

If and Vlookup

I am new to PowerBI and DAX. I am trying to create an aging report for open IT tickets. 

 

My table contains the number of days that the ticket has been open, but I need to return a value (see status message below) based on the number of days that the ticket has been open. 

 

I was able to do this in EXCEL using this formula =VLOOKUP(IF(TODAY()>'IS SR  - Dec Data List All'!$J2,TODAY()-'IS SR  - Dec Data List All'!$J2,0),Age_Range1,2,TRUE)  where J2 is the ticket entry date

 

Age_Range1 has the following:

 

RangeStatus Message
0<= 1 Day
11-30 days
3131-60 days
6161-90 days
9191-180 days
181181-360 days
361>360 days

 

How do I do this in PowerBI?

 

Thanks for your help 🙂

 

1 ACCEPTED SOLUTION
blopez11
Resident Rockstar
Resident Rockstar

Take a look at the link below

This should get you what you want

 

http://www.daxpatterns.com/static-segmentation/

 

View solution in original post

1 REPLY 1
blopez11
Resident Rockstar
Resident Rockstar

Take a look at the link below

This should get you what you want

 

http://www.daxpatterns.com/static-segmentation/

 

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.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

Top Solution Authors