UPDATE POWER QUERY TABLE WITH DATA FROM PREVIOUS AND ACTUAL MONTH

[lauraespinade]

Hi,

 I want to update in power query table only data form the last 4 weeks to minimize the time updating.

I have used this formula, but it only updates the data from the actual month.:

= Table.SelectRows(BME_LOSS_TREE_Table, each Date.IsInCurrentMonth([DATATIME_UTC]))

I try with this other formula, but it updates the data from the previous month, no data from this month :

= Table.SelectRows(BME_LOSS_TREE_Table, each Date.IsInPreviousNMonths([DATATIME_UTC];1))

I try to combine it by using && and || , but without result.

Thanks,

Laura

[lauraespinade]

Thank you!! What I need was your second option

[Vijay_A_Verma · Accepted solution]

You need to use Date.IsInPreviousNWeeks for last 4 weeks. Hence, use below

= Table.SelectRows(BME_LOSS_TREE_Table, each Date.IsInPreviousNWeeks([DATATIME_UTC],4))

if you need dates of current week also to be considered

= Table.SelectRows(BME_LOSS_TREE_Table, each Date.IsInPreviousNWeeks([DATATIME_UTC],4) or Date.IsInCurrentWeek([DATATIME_UTC]))