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
I am not experienced with DAX, but want to create a duration curve in Power BI which is responsive to the user's selections (slicers): I am working with time s
I have a simple PowerBI Matrix visualization and I need to justify columns left or right selectively. However, the Field Formatting section is not available or
I have a PowerBi report with several data sources, SQL query and Excel connector. The SQL data data on our Products whereas the Excel is living data on salesper
elasticsearch-aggregation