Forum Discussion

sakamotothais's avatar
sakamotothais
Icon for Helper III rankHelper III
9 years ago
Solved

filter automatic date in power BI language M

Hi,   Need help. I'm trying to leave my auto filter, so it updates itself. My connection is direct and I am using the language M I want it to always select the current date today, the date fro...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • MarcelBeug's avatar
    MarcelBeug
    8 years ago

    You can take a look at my post again.

     

    So my suggestion would be to adjust your code to take the date from your BookingDate; untested:

     

    let
    Source = Sql.Database("10.0.6.70,1433", "DailyBookings34"),
    DMBookings_BookingByLeg = Source{[Schema="DMBookings",Item="BookingByLeg"]}[Data],
    #"Filtered Rows" = Table.SelectRows(DMBookings_BookingByLeg, each Date.From([BookingDate]) = Date.From (DateTime.LocalNow ()) or Date.From([BookingDate]) = Date.AddDays (Date.From (DateTime.LocalNow ()) , -1) or Date.From([BookingDate]) = Date.AddDays (Date.From (DateTime.LocalNow ()), -7))
in
    #"Filtered Rows"
MarcelBeug's avatar
MarcelBeug
Icon for Community Champion rankCommunity Champion
8 years ago

You are still not sharing the relevant information.

 

Please share a screenshot from the previous step, proving that you have data in your table that should be kept after filtering.

 

Edit: OK after your edit of the previous post I see that you don't have dates in your BookingDate column, so that's why nothing is left after filtering.

sakamotothais's avatar
sakamotothais
Icon for Helper III rankHelper III
8 years ago

already shared, look at the post again

 

 

without the filter I want to mount, making the filter slicer

 

  • MarcelBeug's avatar
    MarcelBeug
    Icon for Community Champion rankCommunity Champion
    8 years ago

    You can take a look at my post again.

     

    So my suggestion would be to adjust your code to take the date from your BookingDate; untested:

     

    let
    Source = Sql.Database("10.0.6.70,1433", "DailyBookings34"),
    DMBookings_BookingByLeg = Source{[Schema="DMBookings",Item="BookingByLeg"]}[Data],
    #"Filtered Rows" = Table.SelectRows(DMBookings_BookingByLeg, each Date.From([BookingDate]) = Date.From (DateTime.LocalNow ()) or Date.From([BookingDate]) = Date.AddDays (Date.From (DateTime.LocalNow ()) , -1) or Date.From([BookingDate]) = Date.AddDays (Date.From (DateTime.LocalNow ()), -7))
in
    #"Filtered Rows"
  • sakamotothais's avatar
    sakamotothais
    Icon for Helper III rankHelper III
    8 years ago

    Dude, it worked, excuse me for any inconvenience. Thank you, thank you.

     

    Thank You