Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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_code | Product_name | Opening_Date | Cancelation_Date | Product_type |
327299 | CUENTAS CORRIENTES COMERCIALES DOP | 11/9/2016 | NULL | CC |
469276 | CUENTAS CORRIENTES COMERCIALES DOP | 7/17/2019 | NULL | CC |
49871 | CUENTAS CORRIENTES PERSONALES DOP | 9/18/2014 | NULL | CC |
80837 | CUENTAS CORRIENTES PERSONALES DOP | 5/14/2015 | NULL | CC |
391698 | CUENTAS DE AHORROS SIN LIBRETA DOP | 1/30/2018 | NULL | FF |
412379 | CUENTAS DE AHORROS SIN LIBRETA DOP | 6/26/2018 | NULL | FF |
413199 | CUENTAS DE AHORROS SIN LIBRETA DOP | 9/28/2018 | NULL | FF |
219594 | CUENTAS DE AHORROS NÓMINA ELECTRÓNICA DOP | 9/26/2014 | 6/22/2016 | DF |
261286 | CUENTAS DE AHORROS NÓMINA ELECTRÓNICA DOP | 7/23/2015 | NULL | DF |
383212 | CUENTAS DE AHORROS NÓMINA ELECTRÓNICA DOP | 11/23/2017 | NULL | DF |
The desired result would be the following (with a unique date filter):
Product type | Opening | Cancelation | Net products |
CC | XX | XX | XX |
FF | XX | XX | XX |
DF | XX | XX | XX |
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |