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

subtract date from formula for custom fiscal year

 

hello 

 

i have this formula that calculates the QTD for every company in my dataset:

 

QTD Total Sales = CALCULATE(daily_sales_7_day_lag[Total Sales],DATESBETWEEN(Date_Table[Date],EDATE(MIN(Date_Table[Date]),-3),MAX(Date_Table[Date]))),"")
 
i use this formula because one of my companies uses a fiscal year. 
 
i need to adjust the formula so it subtracts two days from the MIN date. how can i go about doing that, specific for a certain company? 
 
* DATEADD does not work with EDATE(MIN()) i assume beacuse it needs a column and this returns a date 
 
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
v-danhe-msft Super Contributor
Super Contributor

Re: subtract date from formula for custom fiscal year

Hi @aali ,

You may just minus 2 to achieve your result like below:

1.PNG

Regards,

Daniel He

 

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Highlighted
v-danhe-msft Super Contributor
Super Contributor

Re: subtract date from formula for custom fiscal year

Hi @aali ,

You may just minus 2 to achieve your result like below:

1.PNG

Regards,

Daniel He

 

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 77 members 1,148 guests
Please welcome our newest community members: