Forum Discussion
Impactful IndividualCOMPARE LIST OF VALUES over 2 periods
Hi,
I would like to compare a list of values between 2 ranges of dates, to check which value has Appeared/Disappeared.
For example, I have "text1", "text2", "text3", "text4" in January, and in october I have "text1", "text3", "text4" and "text5" (which means "text2" was removed and "text5" was added.
My dashboard requires 2 filtered dates and each of these dates filtering a list.
My dashboard should do that
Many thanks in advance for your help
Augustin
5 Replies
- Greg_Deckler
Community Champion
Looks like a good opportunity to use EXCEPT.
- augustindelaf
- Greg_Deckler
I'm pretty sure my answer was accurate 🙂 If you want me to be more specific, would need sample data, tables involved, relationships, etc. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
- amitchandak
Super User
How can use two date slicers refer
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Now create two tables or lists using these slicers. and then use
https://docs.microsoft.com/en-us/dax/except-function-dax
You many to combine it with the union or intersect as per need.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
