Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
Proud to be a Super User!
Hi @Kristofferaabo,
Are the two [Country] columns highlighted in red coming from the same table or two separate tables?
Regards,
Yuliana Gu
Hi @v-yulgu-msft,
Yes they are coming from the same tables! One is just summarizing by country
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
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] ) )
Proud to be a Super User!
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] ))
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
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |