Thanks, @Del Swingle . I see where you are going with this, but my workdays table is a single entity to make it more flexible (and account for different hours during DST. Can't figure out how to translate your formula to my fields. I've attached a skinnied ...
I have been working with Power BI for creating reports from Microsoft NAV 2017 and recently came across this error. I did a little bit of searching, but I seem to be the only one having this issue. The odd part is that I have had this report refreshing ...
Hello guys, I'm trying to connect to an Oracle database (that has over 300,000 objects within a certain schema) by using an ODBC connector. Reason being, the Oracle database is hosted in a UNIX environment and I am connecting to it from Windows Server. ...
Hi there, I found that role playing dimension has visual limitation you can't put them (Like Order Qty Vs Ship Qty Vs Return Qty for example) in one table therefore user relation function is my preferred method - this is with one condition which is only ...
Good Day, So this is something I've tried both ways, and either way works. I have not found much discernibly different in the way of performance. I'm just looking at thoughts on preferred methods, and others experience. SCENARIO: I have a few different ...
Thank you Vishesh, Your understanding of the model is pretty accurate. Because an order can be cancelled then later re-opened, a single order can have multiple cancellation reasons, and any cancellation can be used by infinite number of orders. Its ...
HI @Daniel Davis , From what I can see in your schema, is that you have a 2 Dimension tables for order cancellations namely 'Order Cancellations' and 'Order Cancel Reasons' (sorry if got the names wrong) and the fact table 'Orders' I think what you ...
The Power BI World Tour sessions for first three cities of this global tour are now available! Get a look at the popular topics and sessions planned for you, and get to know your speakers! Melbourne (August 21-22) Kelly Broekstra David Alzamendi ...