Forum Discussion

tangutoori's avatar
tangutoori
Icon for Helper III rankHelper III
2 years ago
Solved

Capture Category as per selected date dynamically

Dear Team,   Belwo is my source data. we have two slicers, Date1 SLicer adn Date 2 Slicer. When i select Date 1 Slicer then Category of that particular ID and RO Value should be captured. When i ...
@NeedHelp
@Ritaf1983
@v-rongtiep-msft
@v-shex-msft
@v-yiruan-msf
  • d_gosbell's avatar
    d_gosbell
    2 years ago

    Sorry I don't have a version of Desktop that is that old. But my data model is pretty simple

     

     

    I made the relationship to Calendar2 inactive.

     

    Then the technique I used with the "Date2" measures was the following pattern

     

    Category at Date2 = CALCULATE(
        max( 'DataTable'[Category]),
        USERELATIONSHIP('DataTable'[DATE], Calendar2[Date])
        ,all('Calendar')
    )
     
    R&O Value at Date2 = CALCULATE(
        sum( 'DataTable'[R&O Value]),
        USERELATIONSHIP('DataTable'[DATE], Calendar2[Date]),
        ALL('Calendar')
    )
d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
2 years ago

So you would need to create a date table for each slicer, the attached pbix file achieves the following

 

 

  • tangutoori's avatar
    tangutoori
    Icon for Helper III rankHelper III
    2 years ago

    Dear Gosbell,

     

    thankyou somuch for your support.

    Am facing the below error. which version you have used to developed this soolution. as now am using Report Server vesion Jan2023

    Please let me know how can i opne the file.

     

    Regards,

    Reddy.