-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 51-
(Solution in any language also welcome for Power Query Challenges)
Distribute the amount over month-year for every item.
The division is as per days in that month.
Answer rounded to 1 decimal.
Ex. Row 4 - For 12-Mar-22 to 9-Aug-22, there are 151 days. Hence, amount 16 per day = 16/151 = 0.106
Now, number of days in Mar from 12-Mar-22 : 20
Hence, Mar-22 amount = 20*0.106 = 2.12
Note - For Feb-22, amount is 0 for all items as Feb-22 doesn’t appear in any From or To Date.
Note - The dates in Excel are in US format (mm/dd/yy), so you may need to convert as per your Excel settings.
Download Practice File - https://lnkd.in/dRpM3Eve
(Post answers in Comment. Your approach need not be different from others as long as you have worked out your approach independently)
#powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #excel, #excelchallenge, #python, #r
Excel BI’s LinkedIn Post