Alternate States Issue, Driving me crazy!

[rustyfishbones]

Hi All,

I have the following issue, when I use option 1 below in a straight table, it returns no result, I have 2 date listboxes, one is inherited state and the other has an alternate state of altDate

1. =(WEEK(DATE(MAX({altDate}[Stat Date])))-WEEK(DATE(MIN([Stat Date]))))

if I select all the dates required from the inherited date listbox using option 2. below it works, but thats not how i want them to select

2. =(WEEK(DATE(MAX([Stat Date])))-WEEK(DATE(MIN([Stat Date]))))

Thanks in advance

[rustyfishbones]

@Gysbert_Wassenaar  have you seen a similar issue to this before?

[sunny_talwar]

What exactly are you trying to do? Select Max Stat Date from altDate and subtract Min Stat Date from inherited state? Also, where are you using this chart? In a table or text box object?

[rustyfishbones]

I am using it in an expression in a straight table, I have 2 date list boxes one list box is inherited state the other is altdate.

in list box 1 I select 25/09/2019 and in list box 2 I select 21/12/2019, there are 12 weeks between those dates, when I place the expression in a text object it works, but when I use it in a straight table I get a - not even a zero, I have other expressions in the straight table that work perfectly fine, but the one I post containing altDate returns nothing in the straight table

[sunny_talwar · Accepted solution]

Try this

=Week(Max(TOTAL {altDate} [Stat Date])) - Week(Min(TOTAL [Stat Date]))

[rustyfishbones]

That worked, thank you Sunny