cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Flag first run time by report, day and time

Hi, I'm trying to add a column to flag the first time a report ran by day to get something like this

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: Flag first run time by report, day and time

Hi @oscarmqz,

You can try to use below formula to create a calculate column to tag first date.

```First Time Flag =
VAR first_time =
CALCULATE (
MINX ( VALUES ( Table1[START_TS] ), [START_TS] ),
Table1[REPORT_NM] = EARLIER ( [REPORT_NM] ),
DATEVALUE ( Table1[START_TS] ) = DATEVALUE ( EARLIER ( Table1[START_TS] ) )
)
RETURN
IF ( [START_TS] = first_time, 1 )
```

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |
2 REPLIES 2
Frequent Visitor

## Flag first ocurrence by day and time

Hi, I'm trying to flag the first time a report runs every single day. I'm pretty new to DAX so I'm having a hard time. I've tried using earlier and rankx.

Example

Community Support Team

## Re: Flag first run time by report, day and time

Hi @oscarmqz,

You can try to use below formula to create a calculate column to tag first date.

```First Time Flag =
VAR first_time =
CALCULATE (
MINX ( VALUES ( Table1[START_TS] ), [START_TS] ),
Table1[REPORT_NM] = EARLIER ( [REPORT_NM] ),
DATEVALUE ( Table1[START_TS] ) = DATEVALUE ( EARLIER ( Table1[START_TS] ) )
)
RETURN
IF ( [START_TS] = first_time, 1 )
```

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |

Announcements

#### Challenge: Can You Solve These?

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

#### Community News & Announcements

Get your latest community news and announcements.

#### 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.

#### Win Power BI Swag with Community Kudopalooza!

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

Top Kudoed Authors
Users Online
Currently online: 2 members 227 guests
Recent signins: