DAX EVALUATE SUMMARIZECOLUMNS Week Start Date

[mcornfield]

I am using  EVALUATE SUMMARIZECOLUMNS to pull in only the needed columns from a Tabular Server as its to much Data. 

Pulling in Date makes the Table way to large so i would like to pull it or group it by Week Start date. I used this formula to create the Column in Power BI (Data[Date] – WEEKDAY(Data[Date],2) + 1) But i don't know how to get this to work with EVALUATE SUMMARIZECOLUMNS. Please see my Query below:

EVALUATE
SUMMARIZECOLUMNS(
'Companies'[CompanyID], 
'Customers'[CustomerKey],
'Houses'[HousesKey],
'Products'[ProductKey],
'TransactionTypes'[TransactionTypeName],
'Dates'[Date],
FILTER('Dates','Dates'[Year]>2018),
"Revenue Net", SUM('Transactions'[RevenueNet]),
"Gross Profit", SUM('Transactions'[GrossProfit2]),

)

[v-easonf-msft]

Hi， @mcornfield 

Sorry, I don’t know what you want to calculate with Data [Date] – WEEKDAY(Data [Date], 2) + 1 ?
Can you show your expected result in excel?

Best Regards,
Community Support Team _ Eason

[mcornfield]

What if i want all week Ending Dates? This only shows 12/28 cause of Max i think

[amitchandak · Accepted solution]

@mcornfield, agréguelo como medida e intente

Evaluar
COLUMNAS RESUMIDAS(
'Companies' [CompanyID],
'Customers'[CustomerKey],
'Houses'[HousesKey],
'Products'[ProductKey],
'TransactionTypes'[TransactionTypeName],
'Fechas'[Fecha],
FILTER('Dates','Dates'[Year]>2018),
"Revenue Net", SUM('Transactions'[RevenueNet]),
"Gross Profit", SUM('Transactions'[GrossProfit2]),
"Week End", max('Dates'[Date]) – WEEKDAY(max('Dates'[Date]),2) + 1
)