Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
lherna55
Frequent Visitor

calculate RUN RATE

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.

6 REPLIES 6
lherna55
Frequent Visitor

Hi:

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

lherna55_0-1703616332694.png

 

@lherna55 

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?

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

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

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

@lherna55 

I am unable to open the files, please provide access

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Hi

 

I gave you access.

 

Thanks.

  

Fowmy
Super User
Super User

@lherna55 

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

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.