cancel
Showing results for
Did you mean:
Highlighted
Helper II

## When the two lines will meet?

Hi all,

I have data looks like this

Date   Cost  Revenue

1.4.18 1000\$ 200\$

2.4.18 1100\$ 300\$

and so on.

15.7.18 0\$ 800\$

the line chart looks like this:

I want to calculate in how many days the integrals of the cost will meet the integral of the revenue.

How can I do that?

Thanks

Highlighted
Anonymous
Not applicable

## Re: When the two lines will meet?

You could add a table for Date or Calendar. And create a column in you data like Days from Inception where inception is the first date in you table. Just use the DATEDIFF function. Then create a calculated column which is the difference of Cost and Revenue.

Then create a measure like:

*Measure = Calculate(MAX(DaysFromInception), Filter(Data Table, CostAndRevenueDiff = 0))

Announcements

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

#### Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

#### Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors