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]
    )
)

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
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]
    )
)