Create a Forecast Measure based on monthly values

[Talal141218]

Hello Profis, 

A external Company builded our Data-Warehause and i don't have access to data- transformation. In Addition I have a excel with forecasting monthly values. I want to create a measure, through this forecast measure based on month i can  compaire between actuall sales and planning sales. 

is that possible ? 

Best wishes  

[Anonymous]

Hi @Talal141218 ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng