Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dynamic Date parameter passed to Data source

<PBI noob here> Please help!  Requirement:  Need only Direct Query  I should have the ability to select a single date from a slicer / calendar type of visual in the report  This should be passed ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please check the below picture and the attached pbix file whether it suits your requirement.

     

     

     

     

     

    expected result measure: = 
IF (
    HASONEVALUE ( Data[Start Date] ),
    MAXX (
        FILTER (
            Data,
            Data[End Date] >= MIN ( 'Calendar'[Date] )
                && Data[Start Date] <= MAX ( 'Calendar'[Date] )
        ),
        Data[X]
    )
)

     

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi Anonymous 

please place the following measure in the filter pane on the table visual and select 'is not blank' then apply the filter 

Filter Measure =
COUNTROWS (
    FILTER (
        'Table',
        'Table'[StartDate] <= SELECTEDVALUE ( 'Calendar'[Date] )
            && 'Table'[EndDate] >= SELECTEDVALUE ( 'Calendar'[Date] )
    )
)