topic Re: How to get date between from range filter for smart narrative? in DAX Commands and Tips

How to get date between from range filter for smart narrative?

firstch — Thu, 25 Aug 2022 01:40:32 GMT

Hi all , how can i get date between from this range filter

also , how to calculate max and min base on selected this range filter?

thank you in advance

Best Regard

firstch

Re: How to get date between from range filter for smart narrative?

amitchandak — Thu, 25 Aug 2022 03:23:27 GMT

firstch , Try in a measure

new measure =
var _max = maxx(allselected(slicer),slicer[value])
var _min = minx(allselected(slicer),slicer[value])
return

Re: How to get date between from range filter for smart narrative?

firstch — Thu, 25 Aug 2022 04:42:14 GMT

Hi amitchandak
now i have 2 measure that is minyear ,maxyear can , how can i calculate max value base on my selected range filter above .

best regard
firstch

Re: How to get date between from range filter for smart narrative?

v-cazheng-msft — Mon, 29 Aug 2022 08:20:05 GMT

Hi firstch,

May I know whether your problem has been resolved? If you still have problem, could you please provide some sample data from you slicer field table and date table and make your needs more clear? Thanks in advance!

Best Regards,

Community Support Team _ Caiyun

Re: How to get date between from range filter for smart narrative?

firstch — Tue, 30 Aug 2022 06:48:06 GMT

hi v-cazheng-msft
problem have been solved

Best Regard
firstch