cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BSXS Frequent Visitor
Frequent Visitor

Re: New calculated column with IF/Switch function where data are from Time formated Column

 

 

Hi data is very simple, I just made an excel file with 36 rows, import and made a Time formatted column. Logic works but not if I want to have time between 07:00 to 17:30 and 06:00 to 06:59, It will just return C as value 

 

 

Skärmklipp.JPG

Ale Regular Visitor
Regular Visitor

Re: New calculated column with IF/Switch function where data are from Time formated Column

Not sure if this was solved or not, but:

 

-

NewColumn =

if('data'[Time]<=07:00 && 'data'[Time]>=17:30, "A"),

if('data'[Time]<=06:00 && 'data'[Time]>=07:00, && 'data'[Time]<=17:30 && 'data'[Time]>=22:00, "B"),   

 

also would like to have all other time values into "C"

-

 

It's impossible for any time be smaller than 7:00 and bigger than 17:30. that's why you get alwasy C.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 151 members 2,047 guests
Please welcome our newest community members: