power bi

  1. F

    Power BI Help - Top 2 Box

    Issue: I have data that represents Survey's that I need to calculate in a Top 2 Box fashion for Power BI. I'm new to this and really trying to move towards this. Appreciate any help Example: Scale of 1 to 5, only scores that matter are 4 and 5's. So if I have 10 scores: 1 = 2, 2=1, 3=1, 4=2...
  2. L

    Create column with conditional

    I everyone, im new in power bi / power query and I need to know how to create a column in a table IF the value of a specific column is between a range of one of two different column values. Something like: create a column 4 where the value is the same as the value in column 1 IF this value is +...
  3. L

    Conditional Merge

    Good evening everyone, I had a question ... btw, excuse my bad english: I have a couple of tables, CONTRIBUTION and BILLING, which have an "ID" field with which I relate them (the relationship between the tables is * (CONTRIBUTION) -> 1 (BILLING)), as well as a CONSUMPTION (numeric) field , a...
  4. I

    Enable filters to affect a cumulative measure

    Hi, I've created various measures to help try and show a baseline plan of implementation versus actual, which works as expected when there's no filters applied. However, when I apply a filter, none of the measures update and instead continue to show the full, 'unfiltered', values. I have tried...
  5. S

    DAX Countrow Filter Userelationship not working together

    Does anyone know why the DAX below is not working? Do I have it in the wrong order? BTS Actual = CALCULATE(COUNTROWS('Schedule','Schedule'[Actual Count]), FILTER('Schedule','Schedule'[WO Type]="BTS") USERELATIONSHIP('Calendar'[Date],'Schedule'[Actual date performed])) Power BI just keeps...
  6. L

    How do i create this DAX table in Power Query

    I every one, i have a problem... I have created a table in dax, like this NISCountLT2 = SUMMARIZECOLUMNS(LT2[ID]; "Total"; COUNT(LT2[ID])) to count repeated IDs then i use this code to create a column with ranges for the report Bucket Range = SWITCH( TRUE(); NISCountLT2[Total]=1;"1"...
  7. N

    Power Query - Calendar Table

    Good morning - I have a fiscal calendar that my company creates which I pull into Power BI. Columns include date, fiscal year, fiscal week, day of week, work day, holiday, holiday name, week of month, and fiscal quarter. What I want to do is creat a few custom column in power query that will...
  8. D

    Power query - Updating files before getting values

    I have a query that retrieves information from multiple excel files in a folder The problem I am running into is that those files have formulas that depend on the current date Seemingly, when power query retrieves the data, it doesn't allow the formulas to update first This results in incorrect...
  9. L

    i need to replace some values in a column

    Hello, first that all excuse me for my bad english ;( I need your help, im new with power BI I have a table named LECTURA that contains a column named SMS. The column SMS have a lot of values, and i need to change the value of a part of it. The values i need to change have the structure...
  10. B

    Weighted Measure - Different Criterias

    Hello, I'm looking for help on creating a measure that give me an overall score based off of other score Metrics. I have 2 tables: First table provides the employee scores for the metrics being measured: <tbody> dDate RankGroup Full Name Production% Quality% Adherence% Friday, June 28, 2019...
  11. B

    Matrix Table - Add Column to the end of the Matrix (not on every column)

    Hey Guys, Looking for some help here - I havent been able to find a solution anywhere. I have a matrix table that provides a view of aging inventory. For each client they have a number of days to work the ticket before it is outside of SLA. I want to add a column that shows when those...
  12. K

    DAX Measure to compare against prior update

    I need a DAX measure that compares latest version of financial data against prior version My data table has an'asof' column to tag which version the data originates from (100K+ rows) For example, I would like to compare the full yr 2019 cash number asof Sept 2019 vs. the full year 2019 cash...
  13. S

    What is the Substitute for COUNTIFS date based formula ?

    So I have this formula in excel in my raw data =COUNTIFS([Date range],">="&(EOMONTH(Date,-1)+1),[Date range],"<="&EOMONTH(Date,0)) Power BI however doesn't have this function. I tried to use Calculate, but it is still confusing for me to understand some of these formulas. Can you please show me...
  14. M

    PowerBI: How to calculate/convert Time into Percentage using DAX/Measure

    Hi to all, I managed to get in Excel desired % of time difference from column E, easy job just changed the Data Type to Percentage. What are we calculating is % of these TimeDifferences, one per one (other columns inconsiderable). The calculation I used is: MOD(D3-D2;1) and Column F (%) is just...
  15. S

    Is it possible to teach Power BI a Text mining/analysis without using any platforms.

    So far throughout my searches I always end up being offered MS Cognitive or Azure. Is it possible to somehow teach Power BI to recognize phrases with Python/R (or any other accessible tool) or build some neural network in Power BI to recognize them. Word Cloud is not helping much, as it...
  16. I

    Power Query / DAX solution to Excel formulas (or if this is even appropriate)

    Hello, I've been using Excel for years but have recently been seduced by the appeal of Power BI as a means of providing more 'visually friendly' reports for other users to view and analyse. Whilst I can generally get Excel to do what I want to do (possibly through horrendously inefficient...
  17. O

    Employee turnover calc

    I am trying to find Employee turnover by Year/Company I have and employee table and I have created a Calendar table The employee table has the following columns ID Hire Date Term Date Company Active Status I would like to createa dashboard to show by Company turnover % by Year (2018 &...
  18. J

    Building a dynamic “Top N” Group and “Other” based on Last 12 Months Revenues

    Hello dear Power Bi Community, I'm pretty new into Power BI, so please excuse if I might need some pretty basic help here. I was trying to find some help here already and eventhough similar posts exist, I didn`t find anything yet which would cover my specific needs. I would like to...
  19. R

    Power BI If statement from another table

    Hello.. I' am hoping you can help, below is my code for a PowerBI Query..... the sales data is my main table of data and the "AndCriteria" are filters such as dates names referenced from a cell... for example if someone enters date 01/01/2019 in cell A2 then it will return data from that date...
  20. S

    How to make/create OR operator between fields in Power BI ?

    So I have 2 fields Problem Work Performed Both can contain similar information, thus both can contain specific info. So far apps provide only AND operator. If I create filter for Problem and Work Performed. I will either miss information if one of the fields doesn't contain keyword, or I don't...

Some videos you may like

This Week's Hot Topics

Top