Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
i have table with prices and dates and i want to compare 2 prices from 2 different dates,
ffor that i created another same table with same data
for each table i used a diffrent date filter.
now i wants to compare the 2 different prices in another table
for this i created a measure in one of the tables -
---------------
thank you!
Solved! Go to Solution.
@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
@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 😞
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
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
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |