How to convert Tableau Measures in Power BI DAX expression?

[newbieNG]

I am migrating a Tableau Dashboard in PowerBI where I came across several Measures which I am not able to convert into DAX. If someone can help me understand will be really helpful & appreciative.

1.

{ FIXED : AVG(

{ FIXED DATETRUNC("month", [Start Time]): SUM(IF DATEPART('day', [Start Time])<= DATEPART('day', TODAY())

THEN [Compute Cost] END

)}

)}

2.

{ FIXED DATEPART('weekday', [Start Time]), DATEPART('hour', [Start Time]): AVG(

{ FIXED DATETRUNC('day', [Start Time]), DATEPART('weekday', [Start Time]), DATEPART('hour', [Start Time]):

COUNTD([Warehouse Name])}

)}

Thank you 

[amitchandak]

@newbieNG , Try like

Averagex(Values(Table[Month Year]) ,calculate(
sumx(filter(Table, day([Start Time]) <= day(today()) ), [Compute Cost]), allexcept(Table,Table[Month Year])))

whenever you need a column, make sure it is already created like month year, and year. You may not able to use expression

refer if needed

Tableau Vs Power BI- Chapter 6- LOD- FIXED (Level of Details): https://youtu.be/hU-cVOwDCvY

[newbieNG]

Thanks for prompt reply Amit. So I posted 2 queries , I think you replied for the first one. Also , in your expression where you mentioned Table , is it referencing to the name of table that I have to put?

Sorry I am a newbie to PBI as well as DAX seems complicated to me. Thanks for your help!