Dates between earlist date to latest date, but must account for country

[Kristofferaabo]

Hi,

I would like to get the specific number of days between the first PSSV date and the latest SIV date for each country, as of now I can't get the country filter in so it takes the easliest date across all countries to the latest..

Can this be solved?

[v-yulgu-msft]

Hi @Kristofferaabo,

Are the two [Country] columns highlighted in red coming from the same table or two separate tables?

 

Regards,

Yuliana Gu

[Kristofferaabo]

Hi @v-yulgu-msft, 
Yes they are coming from the same tables! One is just summarizing by country

[v-yulgu-msft]

Hi @Kristofferaabo,

I could not reproduce the problem on my side. Would you please share your .pbix file so that I can test for you?

Regards,

Yuliana Gu

[danextian]

Hi @Kristofferaabo,

Try this DAX measure format

EARLIEST =
CALCULATE (
    MIN ( 'Table'[Date] ),
    ALLEXCEPT ( 'Table', 'Table'[Country Column] )
)

LATEST =
CALCULATE (
    MAX ( 'Table'[Date] ),
    ALLEXCEPT ( 'Table', 'Table'[Country Column] )
)

[Kristofferaabo]

Hi thanks for the reply! I tested this, but it still returns the highest and lowest across all my dates, and not by country..

EARLIEST PSSV =
CALCULATE (
MIN ( 'Site query'[pssv_date].[Date] ),
ALLEXCEPT ( 'Site query', 'Site query'[s.country_name] ))

[danextian · Accepted solution]

Hi @Kristofferaabo,

Is what you are trying to achieve similar with the screenshot below? I used just the same formula. Here's a sample PBIX to check that it works: https://drive.google.com/open?id=10K511DhuNDOm8Xpic7TJBonhAWk_knA5