cancel
Showing results for
Did you mean:
Helper V

## Date plus two months

I have data with a "go live date." I want to show the Amount\$ for anything with a Go live date of 2 or more months away. Example, it is August 2020 I want to show anything with a go live date of October 2020 onward.

Calculate(Sum(Amount\$), GoLiveDate >= ......?

How would I write this into a measure?

3 REPLIES 3
Microsoft

Hi @bhmiller89 ,

Is go live date a measure or a column?

Could you describe it in detail so that we can know your scenario more clearly.

It's better to share a sample pbix with dummy data.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User IV

Perhaps:

``CALCULATE(SUM([Amount\$]),[GoLiveDate]>=DATE(YEAR(TODAY()),MONTH(TODAY())+2,1))``

---------------------------------------

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!

Super User III

@bhmiller89 As a best practice, add date dimension in your model and use it for and time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools.

https://perytus.com/2020/05/22/create-a-basic-date-table-in-your-data-model-for-time-intelligence-ca...

you can add a measure something like this

``CACLULATE ( SUM ( Table[Amount] ), DATEADD ( DateTable[Date], 2, MONTH )``

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Announcements

#### Happy New Year from Power BI

This is a must watch for a message from Power BI!