Forum Discussion
gavinma2022
3 years agoRegular Visitor
Power BI: Groupby using a Calculated Table
Hi community members, I have searched for two days but can't find anything... please help. The data: Salary table: [EmployeeCode, MonthlyUSD, DateStart, DateEnd] A record applies to a_date, i...
amitchandak
Super User
3 years agogavinma2022 , refer if these approaches can help
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785
- gavinma20223 years agoRegular Visitor
Hi Amitchandak,
Thanks for replying.. But I can't understand the solution. My problem is that I don't know how to calculate the median of the column of a temp table....