Skip to main content
cancel
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
javierarandapa
Frequent Visitor

Last Date prev. other date

Hi all, 

 

I've this table: powerbi.PNG

I'm only interested on save the LastDate from 'Fecha Compra' before 'Fecha inicio' for each 'Identificacion' and 'Medicina'. I mean, for this capture, the only one interests me to save is the one that has 'Fecha Compra' = 26/09/2016. How can i do this?

 

Thanks.

1 ACCEPTED SOLUTION
v-qiuyu-msft
Community Support
Community Support

Hi @javierarandapa,

 

In your scenario, you can duplicate the query, add a custom column to decide whether the [FechaCompra] <= [Fecha inicio] then user Group By feature to return maximum date of [FechaCompra]. Then use Merge Queries to merge those two queries based on [FechaCompra]. For more information, check attached .pbix file.

 

q3.PNGq4.PNG

 

 

Best Regards,
Qiuyun Yu

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

View solution in original post

2 REPLIES 2
v-qiuyu-msft
Community Support
Community Support

Hi @javierarandapa,

 

In your scenario, you can duplicate the query, add a custom column to decide whether the [FechaCompra] <= [Fecha inicio] then user Group By feature to return maximum date of [FechaCompra]. Then use Merge Queries to merge those two queries based on [FechaCompra]. For more information, check attached .pbix file.

 

q3.PNGq4.PNG

 

 

Best Regards,
Qiuyun Yu

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

Thanks a lot. 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.