### Need help converting index match formula into powerbi calculated field

Normally  cope with this situation in excel with index match formula that searches dynamically the ccy and looks up the corresponding value
| 1 Replies | 588 Views | Created by MemOez - Wednesday, April 24, 2019 8:13 AM | Last reply by Herbert Seidenberg - Sunday, April 28, 2019 4:01 AM

### Help in calculate date formula

and the expected result Need formula to calculate last day of the year use this trick select dateadd(year, datediff(year, 0, ...
| 6 Replies | 4181 Views | Created by Aaban_M - Friday, May 22, 2009 6:30 AM | Last reply by Aaban_M - Friday, May 22, 2009 3:27 PM

### Need help to write a MDX formula for % OF calculation

I am working with Hyperion, but the MDX language is the same so I think someone here can help me. I have a cube that tracks a Dollar Value (FACE) accross like 10 different ...
| 0 Replies | 7142 Views | Created by vpr80 - Thursday, July 6, 2006 6:20 PM

### Need Help with Average of a calculated field

] was parsed, The end SCOPE statement doesnt match with the OPENING SCOPE STATEMENT. BTW "AvgAbandonTime" is a caluclation in the CUBE, where AvgAbandonTime=C8/C9. In the ...
| 12 Replies | 968 Views | Created by thinkingeye - Friday, May 2, 2014 3:49 PM | Last reply by Ken in Tampa - Wednesday, May 14, 2014 10:47 PM

### Need help with calculated field MDX

I am trying to creating a report on top of a MDX cube, i have requirement where i need to calculate the grand total and use the grand total in a calculated field, ...
| 8 Replies | 4250 Views | Created by ramarama - Tuesday, February 9, 2010 6:07 PM | Last reply by Raymond-Lee - Friday, February 12, 2010 6:33 AM

### Problem with calculating the sum in formula field in the Crystal Report

Hi, I have a Crystal Report which uses data from a Data Table. I have  grouping and calculating sum within the groups. The grouping is by the ...
| 3 Replies | 7099 Views | Created by pet06 - Tuesday, August 7, 2012 6:47 AM | Last reply by Mike Yin - Tuesday, August 14, 2012 5:55 AM

### Help to speed up CALCULATE formula

then return Production (2) - Production (1) or Production(3)-Production(2) respectively (belonging to same version/field/action  Example under of the ...
| 7 Replies | 1695 Views | Created by larsito22 - Thursday, November 20, 2014 10:06 AM | Last reply by - Thursday, February 4, 2016 1:15 AM

### Need help with DAX formula

I'm going to assume that [Source] and [Category] are both fields in tables somewhere. Try the following for a calculated ...
| 11 Replies | 1375 Views | Created by kdankwah - Monday, October 27, 2014 5:04 PM | Last reply by kdankwah - Tuesday, January 13, 2015 4:49 PM

### IF(OR formula in Powerpivot // need help

=IF(H2=\$AW\$2 || J2=\$AW\$2 || L2=\$AW\$2 || T2=\$AV\$2 || W2=\$AV\$2 || Y2=\$AV\$2);\$AZ\$2;\$BA\$2) *** you will have to use fields instead of cells of course for ...
| 3 Replies | 579 Views | Created by trahan_almighty - Friday, February 17, 2017 2:00 PM | Last reply by trahan_almighty - Wednesday, February 22, 2017 3:09 PM

### Need Help with IF( formula in PowerPivot

I have the following formula that works in Excel, that I am trying to move to a PowerPivot calculated column.  I am getting #ERROR now. Here is the Excel ...
| 3 Replies | 871 Views | Created by Scott A Wagner - Monday, March 23, 2015 2:55 PM | Last reply by Michael Amadi - Friday, March 27, 2015 5:02 PM

### Replacing a character in field containing a formula and calculating

I have two tables that contain data.  One is a performance level table that indicates a level that should be met.  In that table there are formulas to ...
| 2 Replies | 4294 Views | Created by cehlinger - Thursday, October 16, 2008 8:22 PM | Last reply by Jingyang Li - Thursday, October 16, 2008 9:17 PM

### Compute running total via a calculated field formula

Hi, The following calculated field formula ([Sessions conducted at Top 5 clients]) generates a table of Sessions conducted at Top 5 ...
| 4 Replies | 3231 Views | Created by Ashish Mathur - Friday, March 8, 2013 12:09 PM | Last reply by Ashish Mathur - Wednesday, February 5, 2014 11:01 AM

### DAX calculation - need help

I need help with a dax calculation. I want to calculate recognized/deferred revenue.  I have an invoice table that ...
| 1 Replies | 2205 Views | Created by lockeness - Monday, August 20, 2012 9:58 PM | Last reply by Christian Wade - Monday, August 20, 2012 10:08 PM

calculations to fix it. The way how [AR] needs to be calculated on [Time 2] dimension leaves is  ([Measure].[AR], [Convert to].[Convert ...
| 2 Replies | 5459 Views | Created by Alec Pojidaev - Thursday, August 26, 2010 3:36 PM | Last reply by Alec Pojidaev - Wednesday, September 8, 2010 1:41 PM

### Convert to Formulas

in the Pivot Table. Convert to formulas is all about doing you own calculations with some cell values coming from ...
| 3 Replies | 3836 Views | Created by nabilas - Sunday, December 13, 2009 7:38 PM | Last reply by Thomas Ivarsson - Sunday, December 13, 2009 8:38 PM

### calculated columns with convert in indexed views

computed columns in indexed views because of imprecise types limitation. Probably even when I use it in "group by" it is still considered a calculation and it ...
| 9 Replies | 675 Views | Created by Rafcio666 - Thursday, October 11, 2018 11:14 AM | Last reply by Puzzle_Chen - Tuesday, October 23, 2018 9:47 AM

### need help with calculated columns

, but can't find any formula #1 in the customers table i want to calculate the yearly order total for each ...
| 2 Replies | 373 Views | Created by LearnMore2017 - Tuesday, March 13, 2018 11:34 PM | Last reply by LearnMore2017 - Thursday, March 15, 2018 7:13 PM

### Formula Calculation

Hi , I need to calculate a formula (C=A/B*1oo) and update result set in a column. Column A comes ...
| 4 Replies | 1169 Views | Created by SR_MCTS - Tuesday, April 30, 2013 9:32 AM | Last reply by Junaid_Hassan - Tuesday, April 30, 2013 10:09 AM