Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have a table with monthly investment values by region and metrics, I need to distribute those monthly investment values into daily values. Any suggestions how I can achieve it.
Solved! Go to Solution.
Allí, @Syndicate_Admin
Pruebe fórmulas como las siguientes:
Year_month = 'Table'[Month]&" "&'Table'[Year]
Number of days = DAY(EOMONTH('Table'[Year_month],0))
daily value = 'Table'[Investment]/'Table'[Number of days]
Saludos
Equipo de soporte de la comunidad _ Eason
Allí, @Syndicate_Admin
Pruebe fórmulas como las siguientes:
Year_month = 'Table'[Month]&" "&'Table'[Year]
Number of days = DAY(EOMONTH('Table'[Year_month],0))
daily value = 'Table'[Investment]/'Table'[Number of days]
Saludos
Equipo de soporte de la comunidad _ Eason
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!