undefined

[Anonymous]

Hi Teams

I have facing a problem.

We want if the date is after 16 then it shows the previous month data,

when the data is before 15 then it shows the previous to previous months data.

[Anonymous]

Hi @Anonymous ,

Please provide some sample data and expected results.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[BA_Pete]

Hi @Anonymous ,

Add this as a custom step in your M query:

Table.SelectRows(
    previousStep, each
    let
        Date.Today = Date.From(DateTime.LocalNow())
    in
    if Date.Day(Date.Today) >= 16
    then
        Date.Month([yourDate]) = Date.Month(Date.AddMonths(Date.Today, -1))
        and Date.Year([yourDate]) = Date.Year(Date.AddMonths(Date.Today, -1))
    else
        Date.Month([yourDate]) = Date.Month(Date.AddMonths(Date.Today, -2))
        and Date.Year([yourDate]) = Date.Year(Date.AddMonths(Date.Today, -2))
)

Pete

[Anonymous]

Not Working