cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
redko_f
Frequent Visitor

Start summing fields after milestone (Date)

Hey guys I'm quite new to Power BI so I have a question. 
I have two tables Calendar and Unit Tracker. 
In the unit tracker I have fields: 
1) DaysIn (Result of calculation of difference betwen IN and OUT) 

2) IN
3) OUT
4) UnitNum
5) WorkshopEnd
6) LastRefurbish (Last date of workshop for Unit)
In the Calendar the main field which I use is Date filtered by latest OUT date and The first IN date.
What I need to do is summrize DaysIN for the Unit from the moment of the LastRefursbish. 
I was tried to use next formula but I receve and error message: 

Annotation 2019-11-06 130736.png
Can somebody tell what is wrong and how I need to change formula.

1 REPLY 1
RaduH
New Member

Hi, as usually in Power BI, there are more ways to achieve the same result>

Prerequisite: please make sure that all dates are formatted as dates: Home->Edit Queries -> Edit Queries - -> Select the columns, right click, Transform -> Data Type: Date.

Alternative 1:

1. Create a Table where you sum days in for each LastRefurbish date.

2. Create a measure which calculates the DaysIn - Last Refurbish:

Simple measure: DATESBETWEEN(<dates>,<start_date>,<end_date>)

More complex / including conditions:

 =CALCULATE(SUM(InternetSales_USD[SalesAmount_USD]), DATESBETWEEN(DateTime[DateKey], 
   
DATE(2007,6,1), 
   
DATE(2007,8,31
  ))

3. Create a relationship between Calendar dates and Last Refurbish and summarize based on Calendar dates.

 

The posted picture is not visible, I hope this helps. If you tweak a bit around the above solutions you will easily get there - I am sure!

 

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors