Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
fidelp27
Frequent Visitor

Filtrar dos fechas en un gráfico

Buenas tardes, 

 

Espero se encuentren bien. Tengo la siguiente consulta: 

 

Tengo una tabla con dos fechas: pre aprobación y venta.

Necesito filtrar las ventas que tuve en relación a las pre aprobaciones del mes. Por ejemplo: 

Si en febrero tuve 500 pre aprobaciones, en marzo 600, y en marzo vendí 700. ¿De las ventas, cuántas corresponden a pre aprobaciones de marzo, cuántas a pre aprobaciones de febrero? 

 

Tengo la tabla de hechos y una tabla calendario que se ven de la siguiente forma: 

 

fidelp27_0-1653606183369.png

 

Agradezco de antemano su ayuda. 

 

Saludos

 

2 ACCEPTED SOLUTIONS

Hi, 

 

Thank you for your help. 

 

If I need to filter two dates, I should to do:

1) Create another Calendar table

2) Connect 1 table to pre approbed date 

3) Connect another table to sell date 

4) Use two data segmentation in the same page

 

Is it right?  

Thanks again 

View solution in original post

Hi @fidelp27 

According to your description, if the month to be filtered and the month to be analysed are both dynamic, you need to create two date tables, one for filtering the date range to be analysed and the other for filtering the months to be analysed within a specific date range (Also, you need to create a premonth column in FactTable)

vxiaotang_0-1653964181318.png

The principle is to use the date range from calendar to filter the createdat of the fact table and then calculate the result based on the selected values in slicer2. The calculation process can be automated using matrix.

vxiaotang_0-1653967400105.pngvxiaotang_1-1653967446754.png

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@fidelp27 , if you want to filter these two date on two different dates say pre-approved and Feb and sold in march , you need two separate Date table one for each .

 

If you need same period pre-approved and sold and Feb , then one date table and inactive relation can do. You can activate the other date using use relation ship

 

refer file attached for the sample

 

 

Hi, 

 

Thank you for your help. 

 

If I need to filter two dates, I should to do:

1) Create another Calendar table

2) Connect 1 table to pre approbed date 

3) Connect another table to sell date 

4) Use two data segmentation in the same page

 

Is it right?  

Thanks again 

Hi @fidelp27 

According to your description, if the month to be filtered and the month to be analysed are both dynamic, you need to create two date tables, one for filtering the date range to be analysed and the other for filtering the months to be analysed within a specific date range (Also, you need to create a premonth column in FactTable)

vxiaotang_0-1653964181318.png

The principle is to use the date range from calendar to filter the createdat of the fact table and then calculate the result based on the selected values in slicer2. The calculation process can be automated using matrix.

vxiaotang_0-1653967400105.pngvxiaotang_1-1653967446754.png

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Thanks for your help! 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.