Forum Discussion
Solved
Compare values based on date filter
Apologies for a possibly dumb question and thanks in advance: I require to create two tables based on the data both with indepedent date filters. So far, so good. I need a third table however...
Hi joe_2802,
Based on my test, you could refer to below steps:
Add index columns for your tables:
Merge your two tables as new table
Create customer columns in new table and remove the other columns:
Result:
You could also download the pbix file to have a view
https://www.dropbox.com/s/x52kamo1ygkq1qv/Compare%20values%20based%20on%20date%20filter.pbix?dl=0
Regards,
Daniel He
Hi joe_2802,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He