I’m not sure if this is more of a DAX question for a Data modeling question. I am trying to create a report that can show how many samples were scanned during a specific time. For example between the hours of 8:00 AM to 10:00 AM the number maybe 100.
I am having trouble figuring out how to link a time table I have created with my date, and firstscans table. There may be a better way to do what I am trying to do but any help would be appreciated.
I have attached an example file of what I have so far. Example File Time.pbix (196.4 KB)
Hi @matthew.wright , we aim to consistently improve the topics being posted on the forum to help you in getting a strong solution faster. While waiting for a response, here are some tips so you can get the most out of the forum and other Enterprise DNA resources.
Use the forum search to discover if your query has been asked before by another member.
When posting a topic with formula make sure that it is correctly formatted to preformatted text </>.
Use the proper category that best describes your topic
Provide as much contextn to a question as possible.
Include the images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.
We have also have threads with some recommendations from other Power BI users which could help. Below are the links where you can view them. Hope this helps.
In order to create/establish a relationship with the “Time” table. You just need to split the “Date and Time” into two separate columns i.e. one column for Date and one column for Time. Below is the screenshot provided for the reference -
And than create a relationship with the “Time” table based onto the fields “Time” from Time table and “created_time UTC” from FirstScans table. Below is the screenshot provided for the reference -
