I am requested to provide the following information from a Teams Channels: Who used a specific mention/tag example @support and how many times(total tags by eac
I have order table like CustomerId OrderAmount Orderdatetime OrderAmountCurrency AAA 120 02/03/2022 02:03 US$120 AAA 20 02/03/2022 02:20 US$20 AAA 320
I have these two tables. Both tables have a relationship by id (one to many) TableA id 1 2 3 TableB (date field is a date/time datatype) id date 1 1/0
In Microsoft Excel I am considering columns and cells to make specific sums in a calculated column, here's an image as an example where the column "G" is where
I have one query can somebody please tell how to show Latest date in a date format So basically, I want to show the latest date selected by default and if the u
My Sales per Month visual looks like the first part of the picture. To show the running total of transactions I use this Measure: Sum Sales Running Total = C
I have a tableau measure which goes like this: ColumnA= IF [Rating Projection Year 1] = 2021 THEN SUM([Weights Ly]*[Next year rating predicted (1)]*[Inclusion F
I have a online Powerbi dashboard. I want to create a cvs which contains a visual summary of all the objects in my dashboard. This is what the export will look
I am currently trying to use dotnetcore to run a script over Powershell. This script uses a library that will authenticate with Azure using a service principal
Any help on this error message in R-script? Im running this in Power BI Error Message: R script error. Error: unexpected symbol in: "# Epilog Auto Generated #
I have a form that allows to upload excel files. How can I read that file in automate and import it into dataverse automatically. I have tried this but not work
I have two tables, Table A contains an attribute (ID1) and Time (date/time format). Table B contains an attribute (ID2) and two time columns Time_start and Time
I need help with Power BI. I need to create a meausure to incorporate in the TABLE visualization (which varies according to the filter from the table DATE) so t
I have Employees and their Overtime hours. There is a cap of 5 hours Max overtime per week, and on basis of that, I submit data to payroll team. However, I am n
I am new in Powerbi. I have requirement to download tiles using powerbi api. tiles reside at below url. https://app.powerbi.com/groups/me/apps/{appid}/reports/{
I have a table with multiple columns. One of these is 'EAN'. In this column there are supposed to be unique values. Unfortunatly this is not the case. Now I wan
I am using Powershell to update credentials on a Power BI datasource based on Sql Azure. The credentials are that of a Service Principal's, I obtain a Sql acces
I am creating a calculated column in Power BI using multiple if and Lookupvalue functions, using Lookupvalue function to return "Yes" if SKU exits in Spare SKU
I am struggling with transforming xml message to table view. Was searching for it, found few solutions, none of those worked or I implemented those poorly. Kind
I have written a python library (ak_sql.py) to query my sql server and written another ".py" script (query_sql.py) to invoke this library and return data in dat