can some one help me to achieve below in dax measure.
[]
In the above table data, 22w05 and 22w09 is showing for two months because the daterange for 22w05 is “January 31, 2022 February 6, 2022” & 2209 is “February 28, 2022 March 6, 2022”
.That particular week count should divide with 5 and. Split the count based on days in the each month.
Below is the example output.
New contributor
santu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.