Migrating SQL metrics to Power BI for newbie

I'm new to Power BI and DAX. I'm not from an Excel background either but a SQL one so not overly familiar with a lot of the DAX functions/methods.

I have the following SQL query...

create table #Metrics
(
dt date,
product varchar(30),
value numeric(9,2),
measure varchar(50)
)

declare @loopstart date
declare @loopend date
declare @thisdate date

set @loopend = dateadd(day, datediff(day, 0, getdate()), 0)
set @loopstart = dateadd(year, -1, dateadd(month, datediff(month, 0, getdate()), 0))

set @thisdate = @loopstart

while (@thisdate <= @loopend)
begin

insert into #Metrics
select 
@thisdate,
x.ITMGEDSC,
count(*),
'MonthFails'
from
(
select
f.IncidentId,
f.createdon,
f.new_completeddate,
f.new_gpitemnumber,
f.new_serialnumber,
i.ACTLSHIP,
f.new_gpcustomerid,
datediff(day, i.ACTLSHIP, f.new_completeddate) daystofail,
i.ITMGEDSC
from 
Failures f join
Installs i on i.ITMGEDSC = left(f.new_gpitemnumber, 6) and f.new_gpcustomerid = i.CUSTNMBR and f.new_serialnumber = i.SERLTNUM
where
f.FailureType = 'Filtered' and
f.new_completeddate between @thisdate and eomonth(@thisdate)

) as x
where
x.ACTLSHIP between dateadd(year, -1, @thisdate) and dateadd(day, -1, @thisdate)
group by
x.ITMGEDSC

insert into #Metrics
select
@thisdate,
x.ITMGEDSC,
count(*),
'Fails'
from
(
select
f.ticketnumber,
f.createdon,
f.new_completeddate,
f.new_gpitemnumber,
f.new_serialnumber,
i.ACTLSHIP,
f.new_gpcustomerid,
datediff(day, i.ACTLSHIP, f.new_completeddate) daystofail,
i.ITMGEDSC
from 
Failures f join
Installs i on i.ITMGEDSC = left(f.new_gpitemnumber, 6) and f.new_gpcustomerid = i.CUSTNMBR and f.new_serialnumber = i.SERLTNUM
where
f.FailureType = 'Filtered' and
f.new_completeddate between dateadd(month, 1, dateadd(year, -1, @thisdate)) and eomonth(@thisdate)
) as x
where
x.ACTLSHIP between dateadd(year, -1, @thisdate) and dateadd(day, -1, @thisdate)
group by
x.ITMGEDSC


insert into #Metrics
select @thisdate dt, ITMGEDSC, count(*) installs, 'Installs' from Installs where ACTLSHIP between dateadd(year, -1, @thisdate) and dateadd(day, -1, @thisdate) group by ITMGEDSC

set @thisdate = dateadd(month, 1, @thisdate)
end;


select i.dt, i.Product, i.value as Installs, isnull(f.value, 0) as Fails, isnull(mf.Value, 0) as MonthFails from #Metrics i left join #Metrics f on i.dt = f.dt and f.measure = 'Fails' and i.Product = f.Product left join #Metrics mf on i.dt = mf.dt and i.Product = mf.Product and mf.measure = 'MonthFails' where i.Measure = 'Installs'

drop table #Metrics

which outputs data like so...

So I've pulled the Failures and Installs tables into Power BI with the aim of replicating the above. I created a new merged query between the Failures and Installs tables called Failures wtih Installs which was efectively a left join between Failures and Installs.

In Power query, I created a new calculated column in the Failures with Installs table to determine if the product was installed within 12 months of it failing.

if [InWarrantyFails_Installs.ACTLSHIP] >= Date.AddYears([CompletedMonth], -1) and [InWarrantyFails_Installs.ACTLSHIP] <= Date.AddDays([CompletedMonth], -1) then true else false

I then created a MonthFails measure in the Failures with Installs table like so;

MonthFails = CALCULATE(COUNTROWS('Failures with Installs'),'Failures with Installs'[InWarrantyFail] = TRUE(),GROUPBY('Failures with Installs','Failures with Installs'[CompletedMonth]))