cancel
Showing results for
Did you mean:

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

Helper IV

## Detect if a vendor is New or Old.

Hi,

I'm stuck trying to identify within a date range if a vendor is new or not in a report of payments by vendor.

I am working with 3 tables.

Pagos : it has all payments for each vendor

Fechas: is a calendar table (it has an active relationship with the table 'Pagos' with the field Payment date

The idea is when the user selects a range of dates from the slicer (From the table 'Fechas'), i am showing all the payments for each vendor in that range of dates(that is working fine),

But now the user requires to know  If the vendor was created during that same date range (it is a new vendor) or if the vendor was created before (it is an old vendor). the date of creation of the vendor is in the table 'Added'.

I tried to do that with different ways but i can find a formula to do that.. Thank you very mch!!

1 ACCEPTED SOLUTION
Resolver I

Hello @gomezc73 ,

I think for what you want this works:

First you need to create an active relatioship (both directional) between Pagos[vendor code] and Added[vendor code]. Then create this measure:

``````New_Old Vendor =
Var _start = MIN(Fechas[Date])
Var _end = MAX(Fechas[Date])
Return

The slicer is based on the Fechas[Date].

Hope this helps.

3 REPLIES 3
Resolver I

Hello @gomezc73 ,

I think for what you want this works:

First you need to create an active relatioship (both directional) between Pagos[vendor code] and Added[vendor code]. Then create this measure:

``````New_Old Vendor =
Var _start = MIN(Fechas[Date])
Var _end = MAX(Fechas[Date])
Return

The slicer is based on the Fechas[Date].

Hope this helps.

Helper IV

I made some changes and now works!!. thank you!

Helper IV

Thank you for respond to my issue. I tried with your solution but i am still receiving wrong values.

i ran the report for April+May and all vendors created in April must show 'New' and it is showing 'Old'

Announcements

#### New forum boards available in Real-Time Intelligence.

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

#### Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors