calculated columns

I'm a beginner with Power Pivot/DAX, and got thinking about that: Given two tables: items and groups, related by columns [groupid]. I create calculated columns in the groups table. There is more than one way to do it: groups[n items 1]=COUNTROWS(RELATEDTABLE(items)) groups[max fact...

Hi, currently I work in excel, power pivot. Here I have added a number of measures and calculated columns. I would like to continue working in Power BI. If I load the current file via "get data", I only have the original data. Is there a way to add the already-written measuers and...

I'm having trouble with inconsistent calculated formulas when adding new rows in a table in Excel. For context, I adapted this video on how to create a searchable drop down list in Excel for a project I am working on. https://www.youtube.com/watch?v=vkPoViUhkxU I'm designing a template which...

I receive a weekly CSV file with the same number of columns, but differing rows. I want to create some sheets/tables to analyze this data, but how do I reference the CSV file each time? I was thinking of simply pasting the data into a "Data" tab that I reference from other sheets or tables, but...

Column 1 6.0.2014-06-06T18:00:00Z Column 2 2014-06-06 I also want to add in my calculation in column2 to convert the date to a format of (TODAY) Thanks in advance, Huggy

Hello everybody. I don't know if I am making my problem more difficult than it is or if I'm asking powerpivot to do too much. I work in the finance department of a law firm so my data is a little different than Sales/Products. I have multiple matter numbers and fees billed on various days. I...

On a Pivot Table across the columns I have a field called "ACT Type." This field has 3 values, Labor, ODC and Excess. Under the values I have two fields: Amount and Qty. The amount values under Labor, ODC and Excess do appear which is good. However, when I add the field Qty. under value...

I have a spreadsheet with line items from Invoices, and each record contains the fields UnitPrice, Quantity, Discount and Freight. I want to perform some analysis, and a TABLE usually fits this bill. I saw a video on YouTube that demonstrated the calculated column functionality while in a...