powerbi

Hi everyone, I am conducting a marketing research survey on the needs of individuals who use Microsoft's Power Pivot/BI products. This survey is very brief and completely anonymous. My goal is to better understand what resources people are looking for on excel and Power Pivot/BI, and what...

Hi I need to know the Monday's date of each week. I have a sales table with sales and want to group all the sales by week. And need to know what week each sales fall under. IE: 7/12/17 would return a result of 7/10/17 as it is the monday of the week. Thanks

Hi I’m looking for a way to have sales starting last Monday for the week. Below is what is use for today’s sales. What formula will pull sales starting Monday. = CUBEVALUE("ThisWorkbookDataModel", "[Measures].[SALES TOTAL NET RETAIL]", "[SALES TABLE].[TRANS DATE].&[" &...

Hello, I'm stuck in one of the business use case where we need to add duplicate entries in a new custom table from the inputs given in other table. e.q. consider i have a table with Subscriber Effective_date Expiriation_date Service_Code Now i want to dynamically create a custom table...

Hi I have an Excel DAX measure for items that are selling well or poorly. I would like to create a Slicer to selected "SLOW" or "FAST" moving items. But I dont know how to go about doing it. I've read something about disconnected slicers. Can anyone help. SELL THROUGH...

Hello All, I have created the custom kpi using below measure. PlanArrows = IF(ISBLANK([PlanSum]),"No Data Available ",[PlanSum])&" "&IF([PlanSum]=[PlanPrevMon],"",IF([PlanSum] > [PlanPrevMon],UNICHAR(8679),UNICHAR(8681))&IF([PlanSum]<=0,"",""))And it works fine for me for perticular month...

Hello All, I am trying to create kpi's like showing UP and Down arrows for different kind of data. But facing multiple issues. I need your help to reolve these issues. 1:- Cant Show Images of UP and Down arrows while creating KPI. Table is Measure for KPI creation is, Measure =...

I am struggling to extract the data from my JSON source (see below) [{"id":"TEST1","created_at":"2017-02-22 11:55:15 +0000","updated_at":"2017-02-22 12:09:56 +0000","created_by":"chris.k@b.com","fields":[{"id<wbr style="color: rgb(0, 0, 0); font-family: Consolas, "Courier New", monospace...

I am fairly new to PowerBI and am working to complete the following goal. I have a large data set in the form of columns A and I would like to have a measure which calculates column H, which I could filter and graph on my report. While playing around with PowerBI I was able to create this...

Hi - When we upload an Excel workbook to SharePoint , every table in that workbook is exposed as an OData feed that can be used in Power Query. Similarly is there any way we also query data in Excel from power bi web app [https://app.powerbi.com] ?

Is there a way to get the historical exchange rates for the dates I have entered in powerbi, so that when there are new dates entered, the exchange rate is automatically placed for that date? I need it to be daily. I tried using json, but it only lets me specify the dates manually, and I need...

I have a column of time data in 24 Hr time: Time 625 844 1241 1566 Where 625 is 06:25 AM. How can I convert this into a usable form for PowerBI? I tried the following DAX query in the advanced editor Column =...

Currently, I have the following table Company---------Date--------Exchange-------Size A-------------------2000----------------A-------------50 A-------------------2001----------------A------------ 100 B-------------------2000----------------B------------450...

Hi! I have two queries in power query editor. I want to load only one query to the spreadsheet. I do not want the other query to load to the spreadsheet. I cannot delete the other query as I have merged it with the one I am going to load. How to perform this? Thanks

My current table looks like this Company-----year----size-----Exchange A---------------2000-----80-------A A---------------2001-----85-------A B---------------2002------90------C I want to allocate the companies into two categories "Big" and "Small". For a particular year, if the companies...

Hello Folks, I am a new PM on the Power BI team and wanted to let you know about a Webinar we have created specifically for Excel Users that want to get started using Power BI. The Webinar is May 17th and starts 3pm PST More information about this free webinar can be found here: Microsoft ...

I want to fetch data from Google Analytics With M (PowerQuery/PowerBI), but want to filter the dimension values on the fily, Let's Say my dimension is "Page" and I want "Pageviews" and "Unique Pageviews" measures, provided that the "Page" is following a regex filter (ex...

Hello I'm sure this is an easy fix, but new to DAX and I hope someone can offer some advice! In Excel [PC District] column has values like GU7, LS1, W1, B2, WF23. I use the formula below in a new column to find the numeric value and remove it so the new column reads GU, LS, W, B, WF...

Hi guys, I am new to power pivot (Less than a week). I am trying to calculate determine the cost difference for a given product each year compared to a give n reference year. My data is as below: <colgroup><col span="3" width="64" style="width: 48pt;"></colgroup><tbody style="border: 0px...

Hi All, I have a powerquery script to create my date table. Think I copied it from powerpivotpro.com (great site) Has been working ok but I just realised that the IsToday column is wrong. Right now it is Wednesday the 9th of September but it thinks today is Tuesday the 9th of September...