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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Tiagottf
New Member

Criação de medidas

Tenho uma planilha com os registros diarios de todas as não conformidades geradas ao longo de 1 ano. Tenho outra planilha que mostra a hora trabalhada em cada mes do ano. 

 

Preciso relativizar os dados dividindo a quantidade de não conformidades geradas de cada mês pela quantidade de horas trabalhadas do respectivo mês.

 

Como consigo fazer isso?

1 REPLY 1
BA_Pete
Super User
Super User

Hi @Tiagottf ,

 

Based on the limited information provided, I'd say the basic things you need to do would be:

 

-1- Ensure that the date columns in both your daily table and your monthly table are actual dates e.g. ensure that your monthly table shows 01/10/23 for October, not "Oct 23" etc.

-2- Create a proper calendar table with a [Month] column and mark it as the date table in your data model.

-3- Relate your calendar table to both fact tables on:

--- Calendar[Date] = monthlyTable[MonthDate]

--- Calendar[Date] = dailyTable[DayDate]

-4- Create a measure something like this:

_nonConfPerHour =
VAR __nonConf = SUM(dailyTable[NonConfValue])
VAR __hours = SUM(monthlyTable[HoursWorked])
RETURN
DIVIDE(__nonConf, __hours, 0)

 -5- Add Calendar[Month] and [_nonConfPerHour] into your chosen visual.

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.