Forum Discussion

ebrodie's avatar
ebrodie
Frequent Visitor
3 years ago
Solved

date filtering usint 2 dates in the table

I am new to PowerBI and loving it so far   I have a simple task list with start and close dates – at least it seems simple.  I would usually use multiple OR conditions in an MS Access query   I w...
Need Help
  • jbwtp's avatar
    jbwtp
    3 years ago

    This returns a table which you can feed to measure, something like:

    Measure = SUMX(Filter('ve2doTaskALL', ([ClosedDate] > Date(2022,9,1) && [closeddate] < Date(2022,9,30)) || ([startdate] < Date(2022,9,30) && (ISBLANK([closeddate]) || [ClosedDate] > Date(2022,9,30)))), [Revenue])

     

    Cheers,

    John

     

ebrodie's avatar
ebrodie
Frequent Visitor
3 years ago

John

you are the BEST!

 

is there a way to pass in as parameters the hard coded dates?

jbwtp's avatar
jbwtp
Memorable Member
3 years ago

Yes, tipically for DAX you either create a measure which would get a value from the dates table managed by a slicer, and use this measure instead of the hardcoded date.

 

 

  • ebrodie's avatar
    ebrodie
    Frequent Visitor
    3 years ago

    jbwtp 

     

    so i am using the between sucessfully.

    now i wantto reference a start and end data that is selected from a calendar by the user

     

    can the user select a start date and end date from an "UNBOUND" control that i can pass into the measure for the filtering of the records?

    • jbwtp's avatar
      jbwtp
      Memorable Member
      3 years ago

      Hi ebrodie,

       

      Do you need any further help with this?

       

      Thanks,

      John