Calculate Total CRM Forecasts From Today Until End Of Month

preview_player
Показать описание
In this video tutorial, I showcase how you can work out a dynamic monthly calculation.

This is perfect for a CRM scenario where you may want to dynamically calculate a monthly sales forecast for the remainder of the month.

In this example, we use the DATESBETWEEN function, which enables us to open up a dynamic date window.

Enjoy working through this one.

***** Video Details *****
2:24 - building DateRange
2:42 - using the TODAY function
3:05 - using the DATESBETWEEN function
3:49 - the CALCULATE function

***** Learning Power BI? *****

***** Related Links *****

***** Related Course Modules *****

***** Related Support Forum Posts *****
Рекомендации по теме
Комментарии
Автор

Learning Power BI?

Related Links

Related Course Modules

Related Support Forum Posts

EnterpriseDNA
Автор

Great video as usual! :)
Can you show us the formula for the measure Total Sales Forecast?
Thank you

catarinapaesdevasconcellos
Автор

Thank you very much
Please how can i use the same formula on the previous month, two months ago and three months ago in order to compare my historical sales with my forecast sales? your answer will really help me. thanks in advance

pierretsapgueu