Recent questions tagged PowerBI

0 votes

725 views

1 answer

powerbi - Difference between CALCULATE(m, x=red) vs CALCULATE(m, KEEPFILTERS(x=red))

What is the difference between CALCULATE(m, x=red) and CALCULATE(m, KEEPFILTERS(x=red)) Apparently they are ... https://dax.guide/keepfilters/ See Question&Answers more detail:os...

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

0 votes

925 views

1 answer

powerbi - DAX create empty table with specific column names and no rows

How to create a table with a specified column name and no rows at all. The following oneliner does what I ... table, in this case Prod_Name. See Question&Answers more detail:os...

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

0 votes

994 views

1 answer

powerbi - DAX REMOVEFILTERS vs ALL

How to substitute REMOVEFILTERS in the following code with old school functions ALL and VALUES instead? This exercise is ... in #"Changed Type" See Question&Answers more detail:os...

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

0 votes

778 views

1 answer

powerbi - DAX conditional sum of two columns with different granularity

This is follow up question of the one asked here. However this time two columns have different granularity and ... budget defined on Brands. See Question&Answers more detail:os...

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

0 votes

908 views

1 answer

powerbi - Power Bi Calculate Growth Over Last Month and Show it in a Matrix

I have a below matrix. I want to calculate the % Growth over month and to show in a matrix Fields ... SPORTS ONE PHARMACY 1188 -100% 1188 See Question&Answers more detail:os...

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

0 votes

761 views

1 answer

powerbi - Custom matrix header

I need to create a custom header like the picture below: I check this link Custom aggregate column in power bi ... then dim6 in the header? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

powerbi - DAX RANKX for within Category

How to calculate ranking for within Category? Say we have sample data with the following expected results: let ... it produces expected results. See Question&Answers more detail:os...

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

0 votes

763 views

1 answer

powerbi - Percent of Total Windowed in Power BI DAX

I have these two tables: A data table... ImaginaryData = DATATABLE ( "Fruit", STRING, "Colour", STRING, "Amount", ... [Fruit]) ) ) I get this: See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

powerbi - Select row with MAX value per category Power BI

How to select row with max value per category in M of Power BI. Suppose we have table: +----------+-------+--------- ... -+------------+-------+ See Question&Answers more detail:os...

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

0 votes

862 views

1 answer

powerbi - How to add Power BI reports in Android native app in 2019

I am developing an Android application in which I should show Power BI reports and tiles with drill down. I ... Please help, thanks in advance. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

powerbi - Finding cummulative sum of MAX values

I need to calculate the cumulative sum of Max value per period (or per category). See the embedded image. So, ... 2016 15 2017 37 2018 54 See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

powerbi - Power BI - Matrix Count Blank Rows

I have created a matrix having data of salesman and their chemist visited. I have added a count formula ... help would be highly appreciated. See Question&Answers more detail:os...

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

0 votes

908 views

1 answer

powerbi - Creating an index column for Power Bi

I have a table of member IDs and transactions in Power BI, I would like to create an index column for it, any suggestions? Regards See Question&Answers more detail:os...

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

0 votes

580 views

1 answer

powerbi - Force DAX SWITCH function to use strict (lazy) short-circuit evaluation

Set up: Similar to this question on a MSDN forum, I have a measure that switches between various other ... -may-2021-feature-summary/#perf See Question&Answers more detail:os...

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

0 votes

959 views

1 answer

powerbi - How to model queries in Power BI for daily append of new data instead of overwriting

I'm trying to build a simple report in Power BI based upon data published on a website. Here is what I ... any pointers. Thanks in advance! See Question&Answers more detail:os...

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

0 votes

619 views

1 answer

powerbi - Power BI Dashboard where the core filter condition is a disjunction on numeric fields

We are trying to implement a dashboard that displays various tables, metrics and a map where the dataset is ... =male, country=Australia). See Question&Answers more detail:os...

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

0 votes

941 views

1 answer

powerbi - Filter SUMMARIZECOLUMNS

How to construct filter tables for SUMMARIZECOLUMNS function? The SUMMARIZECOLUMNS has the following pattern: ... multiple tables. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

powerbi - COUNTIF equivalent in Power BI / DAX?

I have the below table and trying to move from excel to Power Bi. In excel I use =COUNTIFS($A$2:$A$16,"<="&E2,$B$2 ... -19 31-Jan-19 30-Sep-18 3 See Question&Answers more detail:os...

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

0 votes

896 views

1 answer

powerbi - Operations on multiple tables / datasets with Edit Queries and R in Power BI

I have two tables tbl_A and tbl_B in a Power BI file that I'd like to transform and analyze using the Run R ... tables with R in Power BI? See Question&Answers more detail:os...

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

0 votes

888 views

1 answer

powerbi - Power BI: How to use Python with multiple tables in the Power Query Editor?

How can you create a new table with a Python script that uses two existing tables as input? For example by performing ... -15,13 2108-10-16,14 See Question&Answers more detail:os...

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

0 votes

627 views

1 answer

powerbi - Power BI Embed URL-multiple filters

I have been trying to filter my embedded PBI report using the filter query syntax: &$filter={tableName/fieldName} eq ... the Power BI embed URL? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags