topic Re: calculate RUN RATE in DAX Commands and Tips

calculate RUN RATE

Anonymous — Thu, 21 Dec 2023 20:38:51 GMT

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.

Re: calculate RUN RATE

Fowmy — Thu, 21 Dec 2023 20:52:15 GMT

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

Re: calculate RUN RATE

Anonymous — Tue, 26 Dec 2023 18:49:12 GMT

Hi:

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

Re: calculate RUN RATE

Fowmy — Tue, 26 Dec 2023 19:02:53 GMT

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?

Re: calculate RUN RATE

Anonymous — Tue, 26 Dec 2023 21:03:56 GMT

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

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

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

Re: calculate RUN RATE

Fowmy — Wed, 27 Dec 2023 03:37:22 GMT

Anonymous

I am unable to open the files, please provide access

Re: calculate RUN RATE

Anonymous — Wed, 27 Dec 2023 14:26:20 GMT

I gave you access.

Thanks.