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.
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:
Agradezco de antemano su ayuda.
Saludos
Solved! Go to Solution.
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)
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.
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.
@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)
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.
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!
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 |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |