Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

New Row With Calculated Values

Hi,   So, I'm trying to build a table with the company name, date, the number of accidents (and other variables, but let's simplify) and a calculated formula between the 2 dates I select (for which...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi, I did a project similar to your needs. In my scenario company needs to get value diferences between selected dates.My measures is like 3 and 2 of them calculates the min and max of selected date, other one is for getting the difference values by substracting them. Maybe it can light you up 🙂 I pasted my measures below.

 

 

DatesValueMin = CALCULATE(SUM('ValueTable'[Actuals]),
DATESBETWEEN( Dates[Date],
MIN(Dates[Date]) -30,
MIN(Dates[Date])))
DatesValueMax= CALCULATE(SUM('ValueTable'[Actual]),
DATESBETWEEN( Dates[Date],
MAX(Dates[Date]) -30,
MAX(Dates[Date])))
DateDIFF = [DatesValueMax]-[DatesValueMin]

 

 

After that i build the matrix table visual with DateDIFF and other fact table columns.

 

Hope it helps you if you have questions feel free to ask.