Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

I have implemented bellow logic in tableau. I need same to be implements in power bi please help.

‎05-06-2019 06:06 AM

IF [Opened by] = [Closed by] AND DATE([Opened])= DATE([Closed]) AND [SA AGENT CLOSE] = "SA" THEN 1 ELSE 0 END

Labels:
Message 1 of 2
180 Views
0
1 ACCEPTED SOLUTION
v-frfei-msft
Community Support
Community Support

‎05-06-2019 07:54 PM

Hi @Anonymous ,

 

Plz have a try.

 

a =
IF (
    [Opened by] = [Closed by]
        && DATE[Opened] = DATE[Closed]
        && [SA AGENT CLOSE] = "SA",
    1,
    0
)
Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

Message 2 of 2
171 Views
0
1 REPLY 1
v-frfei-msft
Community Support
Community Support

‎05-06-2019 07:54 PM

Hi @Anonymous ,

 

Plz have a try.

 

a =
IF (
    [Opened by] = [Closed by]
        && DATE[Opened] = DATE[Closed]
        && [SA AGENT CLOSE] = "SA",
    1,
    0
)
Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Message 2 of 2
172 Views
0

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

View All