Forum Discussion
Creating a measure using multiple tables
HI cass_butchard ,
Can you check if the link helps
Solved: Derive open defects from the past using Dax - Microsoft Fabric Community
Cheers
CheenuSing
Anonymous - Unfortunately I have re-created the above and it gives me the exact same figures as my original measure - Which is not the correct number is it does not align to the figures from the system. The only thing I can consider is amending the date field used in the axis as it changes the figures when I use Date Raised or Completion Date but when I use a standard date field the numbers are the same as date raised. I really appreciate all your time and assistance in this matter.
The correct figure for this should be 996
Hi cass_butchard ,
It is very difficult to simulate the data. If possible just share the data with only columns to be used in the visuals and your date table, then only can provide a solution.
Cheers
CheenuSing
I have attached the pbix let me know if any issues Anonymous
Hi cass_butchard ,
Unable to download pbix , as the link is pointing to sharepoint.
Put it in One Drive or Google Dirve and share the link here.
My email id is [email protected]Cheers
CheenuSing