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