Forum Discussion
Comparing two tables with time data - forecast versus actuals
Hi,
In the Dates Table there are blanks appearing in the Date column. Remove those blanks rows.
Thank you Ashish_Mathur for your reply.
I have tried to create a Many to One relationship, but the system won't let me, saying "The cardinality you selected isn't valid for this relationship."
Is there anything you can see that I am doing incorrect?
Kind regards,
Neil
- Ashish_Mathur
Super User
Hi,
I'll need to see your PB file. Share the download link.
Hi Ashish_Mathur,
Here is a link to the PBIX file
https://drive.google.com/file/d/15jITA_CuhBDJw_PkCBSP97bZBYiTXm9N/view?usp=sharing
Kind regards,
Neil
- Ashish_Mathur
Hi,
Ensure that your staff number in both the Actual and Forecast table match with the staff number in the staff table. Click on Refresh All.
Download the PBI file from here.
Hope this helps.