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 tengo un problema. Tengo la tabla factura con una columna fecha emisión. Necesito calcular la fecha de vencimiento según la condición de pago (contado, Cta Cte 30 días) . Es decir si una factura tiene condición de pago Cta CTE 30 días sumarle a la fecha de emoción 30 días.
Me podría ayudar a resolverlo.
Saludos
Solved! Go to Solution.
Hi @Augusto_Soto ,
According to your description, I made a sample, and here is my solution.
Sample data:
Create a calculated column.
Column =
IF (
'invoice table'[payment condition] = "Cta Cte 30 days",
'invoice table'[issue date] + 30
)
Final output:
If I have misundstood your meaning, please provide your desired output and pbix file without privacy information.
I attach my sample below for your reference.
Best Regards,
Community Support Team _ xiaosun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Augusto_Soto ,
According to your description, I made a sample, and here is my solution.
Sample data:
Create a calculated column.
Column =
IF (
'invoice table'[payment condition] = "Cta Cte 30 days",
'invoice table'[issue date] + 30
)
Final output:
If I have misundstood your meaning, please provide your desired output and pbix file without privacy information.
I attach my sample below for your reference.
Best Regards,
Community Support Team _ xiaosun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Augusto_Soto , I believe you can find the answer in the community. For example, https://community.powerbi.com/t5/Desktop/DAX-Formula-to-add-30-days-to-a-time-date-column/m-p/543806.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |