calculate function

Hello everyone, I am new to DAX and Power Pivot, I apologize in advance if there is a similar thread I did not see. I am using Excel 2016, I need to use USERELATIONSHIP in the CALCULATE function to use an inactive relationship in the data model (I need it for a slicer). I am using this formula...

Dear Team, Question #1: If I create a Calculated Column with this aggregate calculation: SUM-Aggregate =SUM(PlayersTable[Salary]) Is this a correct statement: “Aggregate functions are affected by Filter Context, but will ignore Row Context and will show the same aggregated number in every...

Dear Team, I am creating a Calculated Column to simulate VLOOKUP Approximate Match. The goal of the formula is to retrieve the Cost discount based on number of units sold. I have a table named “disCostDiscounts”, where the first column is Units and the second column is Discounts. The table looks...

Hi, I have a couple of tables in PowerPivot: 1. A Stock table - WKRelStrength whose fields are: Ticker, Date, StockvsMarket% (values are percentages), RS+- (values can be 0 or 1) 2. A Calendar Table - Cal with a Date field. There is a many to one relationship between the tables. I am trying...

I used the RELATED formula to to create a Calculated Column called fact_ActualsOrders_ES[Accrual] or "Accrual": =IF(related(dim_posting[doc_type_cd])="YK",1,0) The values came over correctly, so I created (3) measures to calculate the the total amount, all the "1"s, and all the "0"s...