cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Getting a single date to filter or creating a new column to work with dates

Hi,

 

I have a problem. I want to filter a dashboard using only one date filter. To get you into context, my table looks like this:

Client_codeProduct_nameOpening_DateCancelation_DateProduct_type
327299CUENTAS CORRIENTES COMERCIALES DOP11/9/2016NULLCC
469276CUENTAS CORRIENTES COMERCIALES DOP7/17/2019NULLCC
49871CUENTAS CORRIENTES PERSONALES DOP9/18/2014NULLCC
80837CUENTAS CORRIENTES PERSONALES DOP5/14/2015NULLCC
391698CUENTAS DE AHORROS SIN LIBRETA DOP1/30/2018NULLFF
412379CUENTAS DE AHORROS SIN LIBRETA DOP6/26/2018NULLFF
413199CUENTAS DE AHORROS SIN LIBRETA DOP9/28/2018NULLFF
219594CUENTAS DE AHORROS NÓMINA ELECTRÓNICA DOP9/26/20146/22/2016DF
261286CUENTAS DE AHORROS NÓMINA ELECTRÓNICA DOP7/23/2015NULLDF
383212CUENTAS DE AHORROS NÓMINA ELECTRÓNICA DOP11/23/2017NULLDF

 

The desired result would be the following (with a unique date filter):

Product typeOpeningCancelationNet products
CCXXXXXX
FFXXXXXX
DFXXXXXX

 

Where I could count the amount of accounts opened and canceled in an specfic date range through a filter.

 

At the moment, I need to use 2 filters and use manually change them to the same date, and I cant get the net numbers. This makes my report bulky and unintelligible.

 

I was thinking about creating a table that actually tells you if the product is being Canceled or Opened at an specific date, making the date variable unique and creating a new variable named "Status". This means that all products would have at most 2 entries (Opened and Canceled).

 

In case you have a way to do this or another solution, dont hesitate to write.

 

 

Thanks in advance,

 

IC

1 REPLY 1
TomMartens
Super User
Super User

Hey,

 

please be aware that the solution to this kind of question is not as simple as you might hope.

These kind of questions is called "events-in progress", to find an answer to your question start reading this excellent article: https://blog.gbrueckl.at/2014/12/events-in-progress-for-time-periods-in-dax/

 

Hopefully this provides some new ideas.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.