Lars Ole Sørensen
Member
Hi,
I want to make a measure that sum the column "kvantum" based on date criteria columns "landingsdato" and "salgsdato". When I in the timeline slicer choose the year 2018, the measure should show "kvantum" values when the criteria for "landingsdato" and "salgsdato" is in the year 2018.
My measure show a wrong value when i choose the year 2018 in the timeline slicer. I get the value 1.108.733 when the correct value is 1.107.738. The error is that i get a value from a row that contain "landingsdato = 31.07.2018" and "salgsdato=29.01.2019". This row should not be in the sum. The measure shows the correct value when I choose the year 2019 in the timeline slicer.
I hope someone can help me with this.
Thanks in advance.
Regards
Lars Ole
I want to make a measure that sum the column "kvantum" based on date criteria columns "landingsdato" and "salgsdato". When I in the timeline slicer choose the year 2018, the measure should show "kvantum" values when the criteria for "landingsdato" and "salgsdato" is in the year 2018.
My measure show a wrong value when i choose the year 2018 in the timeline slicer. I get the value 1.108.733 when the correct value is 1.107.738. The error is that i get a value from a row that contain "landingsdato = 31.07.2018" and "salgsdato=29.01.2019". This row should not be in the sum. The measure shows the correct value when I choose the year 2019 in the timeline slicer.
I hope someone can help me with this.
Thanks in advance.
Regards
Lars Ole