Welcome To Ask or Share your Answers For Others

Recent questions tagged PowerBi

0 votes

1.0k views

1 answer

powerbi - Return top value ordered by another column

Suppose I have a table as follows: TableA = DATATABLE ( "Year", INTEGER, "Group", STRING, "Value", DOUBLE ... maximum, much like the MAXIFS Excel function has. Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.5k views

1 answer

powerbi - Export to file for Power BI Report using bookmark function

It looks like in late 2020, the feature that allows you to export a PowerBI report with a specific bookmark ... 65830885/export-to-file-for-power-bi-report-using-bookmark-function...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

powerbi - Diverging conditional formatting with measure in Power BI

Is it possible to conditionally format a measure with diverging colour in Power BI? Scenario: I need to ... /65832075/diverging-conditional-formatting-with-measure-in-power-bi...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.4k views

1 answer

powerbi - How do we add custom rows using in power bi based on specific string in a column

Need suggestions how do we create rows to existing table which is pulled in Power BI through direct query. For instance ... -using-in-power-bi-based-on-specific-string-in-a-column...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

powerbi - Power Bi forecast projected sales accross days / months between a date range

I am trying to create a monthly forecast for a list of clients that have different start and end dates for ... bi-forecast-projected-sales-accross-days-months-between-a-date-range...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.4k views

1 answer

powerbi - Power BI top gainers

I would like to create a Matrix visualizing MOM top 10 gainer and decliner based transaction count for the ... https://stackoverflow.com/questions/65842639/power-bi-top-gainers...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.5k views

1 answer

powerbi - Power BI 100% stacked area chart

Hi I am wanting to get the same effect as the '100% stacked column chart' but using an area chart visual ... ://stackoverflow.com/questions/65844156/power-bi-100-stacked-area-chart...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

powerbi - Count unique matching items with filter as a calculated column

I have two tables are Data and Report. Data Table: In Data table contain three columns are Item, status, ... 65846163/count-unique-matching-items-with-filter-as-a-calculated-column...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

powerbi - How can I create a summarized table that keeps all columns from the table being summarized?

I have a data table that I want to summarize. It's organized by date, ID, and then tons of KPI columns. I ... -create-a-summarized-table-that-keeps-all-columns-from-the-table-being...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

powerbi - How to translate a Tableau FIXED LOD to Power BI?

I have a FIXED LOD with multiple dimensions that looks likes this: { FIXED [Customer ID], [Quarter], [Product Type ... /65852528/how-to-translate-a-tableau-fixed-lod-to-power-bi...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

powerbi - Why do companies use Snowflake + BI solutions over native analytics?

I'm in the process of researching how to get useful business insights from our company's Zendesk data, and ... /why-do-companies-use-snowflake-bi-solutions-over-native-analytics...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

powerbi - I cannot go pass the Database creation stage in configuring report server for Power BI

Please I am trying to configure my Report Server for Power BI Service but I cant go pass the creation of ... pass-the-database-creation-stage-in-configuring-report-server-for-po...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

powerbi - How to build a regression equation in power bi from model summary?

How to build the regression equation from the model coefficient to do a sort of what-if analysis as in where if u ... -to-build-a-regression-equation-in-power-bi-from-model-summary...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

powerbi - How does CALCULATE, SUM, MAX and <= logically work for cumulative total?

Cumulative Total = CALCULATE ( SUM ( Table[Value] ), FILTER ( ALL ( Table[Index] ), Table[Index] <= ... 65856716/how-does-calculate-sum-max-and-logically-work-for-cumulative-total...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

powerbi - Dax Measure - SUM next n Months based on Fiscal Calendar

I have a transactional table for all upcoming orders in the next 36 months. The structure is like Extract Week - ... 65860989/dax-measure-sum-next-n-months-based-on-fiscal-calendar...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

powerbi desktop - Power BI measure totals

I stack now for 3 days and cannot solve the issue - I have PB model where I need to calculate certain ... from:https://stackoverflow.com/questions/65861639/power-bi-measure-totals...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

powerbi - How does ALL (tablename/columnname) work when used as 2nd parameter of CALCULATE?

The model has sales fact and product dimension. There is M:1 relationship on product_id column. Assume there ... tablename-columnname-work-when-used-as-2nd-parameter-of-calculate...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

powerbi - DAX options to filter 1 side on 1:M relationship

I have salesman dimension and sales fact with 1:M relationship on salesman_id. I am trying to create a measure ... /65864106/dax-options-to-filter-1-side-on-1m-relationship...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

powerbi - Which table gets expanded in DAX CALCULATE/SUM?

I am new to the concept of table expansion and trying to understand which of the table gets expanded? For ... com/questions/65864174/which-table-gets-expanded-in-dax-calculate-sum...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

powerbi - Why does Sales (CALCULATE/FILTER) not restrict itself to the product color for that row?

DEFINE MEASURE Sales[Average Sales Amount] = AVERAGEX ( Sales, 'Sales'[Quantity] * 'Sales'[Net Price] ) EVALUATE ... calculate-filter-not-restrict-itself-to-the-product-color-for-t...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

powerbi - Power BI - Matrix Show Empty Columns and Rows When Filtered

I am trying to build a matrix so that all columns and rows keep showing even when there is no data when ... /65868824/power-bi-matrix-show-empty-columns-and-rows-when-filtered...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.5k views

1 answer

powerbi - DAX Measure for SQL NOT EXISTS

I would like to add an incremental refresh for one of our biggest transactional tables. This transactional table ... .com/questions/65869963/dax-measure-for-sql-not-exists...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

powerbi - Processing errorErrorNonExistentMailbox: The SMTP address has no mailbox associated with it

I am getting the following error when I try to refresh the powerbi data source (Microsoft ... processing-errorerrornonexistentmailbox-the-smtp-address-has-no-mailbox-associa...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

powerbi - Change column display in Power BI power query

I have a fiscal year column, fiscal period, and fiscal quarter. The Fiscal Quarter column is calculated by ... /questions/65879271/change-column-display-in-power-bi-power-query...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

powerbi - How to Sort years in ascending or descending orders in power BI

I have my data like - Course_Code Source Learning 2019-20 BAC 2019-20 SC_casting 2019-20 Rubber melt 2019-20 ... to-sort-years-in-ascending-or-descending-orders-in-power-bi...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

powerbi - custom visiualization in Power BI with bars in table

I need to recreate a visual of which i only have as an image and i have no clue how to get this ... com/questions/65885226/custom-visiualization-in-power-bi-with-bars-in-table...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

powerbi - Can we compare a row value with another row value in the table and highlight it in Power BI?

I have a table where 3 columns can have same value Example: Name Score_a Score_b Score_c A 12 15 18 B 3 3 3 C ... -a-row-value-with-another-row-value-in-the-table-and-highlight-it...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

powerbi - Dax for multiple condition column

I have to create an addition column: Invoice I want to filter by criteria (MONTH PAYMENT,Resume Date ... //stackoverflow.com/questions/65887571/dax-for-multiple-condition-column...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

To see more, click for the full list of questions or popular tags.

...