Forum Discussion

vijayvizzu's avatar
vijayvizzu
Helper III
5 years ago

Last Week comparison not working properly

Hi I have created a measure to compare the current week value with last week value. Its working fine in some pages, but all.   X_Test_Measure = VAR _LW_Price = LASTNONBLANKVALUE( DATEA...
Need Help
v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, vijayvizzu 

 

If you are talking about date slicer, then you can directly control the range of date selection on the filterpane to meet your needs.

Like this:

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.


Best Regards,

Community Support Team _ Janey

vijayvizzu's avatar
vijayvizzu
Helper III
5 years ago

v-janeyg-msft 

Thanks for the suggestion, but how it can be dynamic ? I want to filter publish dated for a particular Source only, i have multiple sources in my main table. 

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    5 years ago

    Hi, vijayvizzu (I took a long vacation due to illness)

     

     

    I don't know your specific thoughts, but it should be possible.

    You can create a measure and use it in filter pane to filter date dynamically like this:

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please upload some insensitive data samples and expected output.


    Best Regards,

    Community Support Team _ Janey