Report Builder Connection to OLE DB
Hello, I am able to connect to OLE DB on Power BI Desktop, however when trying to use Report Builder (OLE DB Data Sources are defined on the on-premise report server), I am receiving the following error The 'OraOLEDB.Oracle' provider is not registered on the local machine. I have tried to also install ODAC 32bit for Report builder but as my Windows version is 64bit, it did not work. Any ideas?
How to create Start Time and End Time Slicers for single Datetime column
Hello Team, We have one Table. This is the below columns, Date-Time , value and Legends. How to create different Start Time (Hours, Minutes ) and End Time (Hours, Minutes) Slicers . Please find the below screenshot for reference
Sort by ASC when value is present
Hello, I'm trying to sort a column, by another column when it's present. The picture shows Categories, in bold, Names as unbolded text, and beneath the names not visible in the picture is a GL number for each name. This GL number is only present in names under the category SG&A. I'm trying to sort these values by ascending them in my matrix. Any ideas?
Count number of working days current month
Hi all, I am trying the build a sales report and for one metric I would like to show the average tonnes sold per day. In order to do this, I need to embed a dynamic calculation in my calendar table that count the amount of working days (mon-fri) past in the current month. This calculation needs to reset itself every single month. On top of that, I would like to save the total working days in the month when the month has completed. I cannot wrap my head around this and hope that one of you can help me out. Thanks
