Apply value based on calculation

[billuran2009]

Have facts table:

Department; Facility; Date; Value

Have a Table that needs to assign a weight based the daily averge of the value

Departement; Facility; Date; Daily Avg; Weight

I need to assign the weight to the daily average for each facility a department line for each day.

So if Department A; Facility XXX; on date 1/1/21 had a daily average of 5 assign the appropriate weight in the 2nd table.

My facts table is about 2m records.

[Icey]

Hi @billuran2009 ,

Could you provide a simple sample with your expected result to help us understand your requirements better?

Reference: How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,

Icey