Hi, I'm trying to subtract 5 years from a date column based on the criteria of another column. I can't seem to get it right, this is one attempt, Column = IF(AND(sheet1[Next Service Pin] = "5 Year Pin","Y"),DATEADD(sheet1[Next…
Formula to subtract days based on a date column 10-28-2019 05:58 AM Ive such a simple question but im unable to fix it. I need to plan an activity base upon another activity and therefore i need to subtract 14 days from a date column but the result returns a date in th...
Get date value of parameter and subtract 1 month Get distinct values from filed to the textbox separated by commas Get report permissions using query Get second and third value from dataset Report Builder Get text after space on string SSRS Get the number of Days within the Current month Get...
Subtract Measure Values from Column 11-06-2020 09:03 AM Is there a way to subtract column values [Rules] from a measure? My measure which gives me number of working days in a month is: Measure 5 = VAR _Month = CALCULATE(COUNT(DimDate[Days in Month]),FILTER(DimDate,'DimDate...
Formula to subtract days based on a date column 10-28-2019 05:58 AM Ive such a simple question but im unable to fix it. I need to plan an activity base upon another activity and therefore i need to subtract 14 days from a date column but the result returns a date in the...
Get date value of parameter and subtract 1 month Get distinct values from filed to the textbox separated by commas Get report permissions using query Get second and third value from dataset Report Builder Get text after space on string SSRS Get the number of Days within the Current month Ge...
From the example dataset below, I'm looking to subtract "Completed On" dates that have statuses SFT which are followed by REA.For example, for Equip_Num 367584264, I need the Date difference between 5/24/2022 and 5/17/2022.It’s important that I only subtract only rows with status SFT...
DAX is easy, CALCULATE makes DAX hard... Message 2 of 7 48,789 Views 9 Reply Anonymous Not applicable In response to Greg_Deckler 11-11-2021 07:11 AM Hi Im experienceing a problem now where I go month - 1 and it seems to be only subtrac...
DAX is easy, CALCULATE makes DAX hard... Message 2 of 7 49,020 Views 9 Reply Anonymous Not applicable In response to Greg_Deckler 11-11-2021 07:11 AM Hi Im experienceing a problem now where I go month - 1 and it seems to be only subtracting 30 da...
DAX is easy, CALCULATE makes DAX hard... Message 2 of 7 51,664 Views 10 Reply Anonymous Not applicable In response to Greg_Deckler 11-11-2021 07:11 AM Hi Im experienceing a problem now where I go month - 1 and it seems to be only subtracting 30 d...