Forum Discussion
comparing same data for 2 different dates
- 5 years ago
oren , not very clear. Refer to my blog if that can help
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
thank you
i read your blog - it did helped me to find how to compare data for 2 diffrent dates which is what is need.
the problem is that i also need to see the actual data (see the 2 matrix in the picture i sent), and if i use your method , than i cannot use the dates filters to see the actual data since i need to remove the connection between the date tables and the main data table (as you said in your blog - "Please note that we have not performed any join here with the Sales table. All three tables are independent tables.")
again , the main issue is to see metrix data for each dates (2 dates) and next to it, the diffrences.
i hope i was clear enoght .
thank you again.
i also tried this solution :
but it didn't worked well (it is working only if i put the same dates, if not it five me te data of the first tabe)
in the red i put the "measuer 3" , did not working 😞
- oren5 years agoHelper III
ok
so it looks like i fount what i need. i did used the solution above (just had a little problem with an extra table i was needed to deleat)
thank you very much
- v-yingjl5 years agoCommunity Support
Hi oren ,
So has this issue been solved? If it has been solved, glad to hear that. You can accept the suitable reply as solution, that way, other community members could easily find the answer when they get same issues.
Best Regards,
Community Support Team _ Yingjie Li