Forum Discussion
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...
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
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.
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?