Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
91 | |
77 | |
71 | |
64 | |
58 |
User | Count |
---|---|
106 | |
97 | |
76 | |
63 | |
61 |