calculate RUN RATE

[Anonymous]

Hi, I need Calculate the run rate in power bi;

in excel I have the formula

%compliance/daysworked*days of the month

in excel I have the formula
% compliance/days worked*days of the month

I try to do the same in power bi but is not working. I am new using power bi so I dont'n know exactly what i need to do.

Can someone help me please.

[Anonymous]

Hi:

In this moment I have this table, I need add the run rate, I prefer a Measure.

[Fowmy]

@Anonymous 

Shared information is incomplete, please answer the following question for you formula 

% compliance/days worked*days of the month

% compliance: Okay
days worked: Which column has this information ?
days of the month: Form where do you want me to calculate this?

[Anonymous]

sorry.

ok, 

the days worked come from DATA AGENTES ( Column FECHA),because the information is update daily here.

and the days of the month would have to come from the DATA_TABLE( is a calendar table).

I attach a file of power bi

Spoiler

Spoiler

https://docs.google.com/spreadsheets/d/1KV2-TYiWL4PN4xrghnMHowWJCI9nuZE-/edit?usp=drive_link&ouid=10... 

https://drive.google.com/file/d/1WNklT-almLJWbfHc1FKwodwR6L_lbHNl/view?usp=drive_link  

[Fowmy]

@Anonymous 

I am unable to open the files, please provide access

[Anonymous]

Hi

I gave you access.

Thanks.

[Fowmy]

@Anonymous 

What are the columns in your table and confirm if you need a Measure or a Column?

Share a screenshot of your data or paste a dummy data table