Forum Discussion

kalspiros's avatar
kalspiros
Helper I
1 year ago

Calculating forecasting values.

Hello all,   I have a measure that works all great. The measure takes the deadline of projects and based on this, it calculates the number of working days and multiplying with the hourly rate of t...
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi kalspiros ,

 

First of all thanks to Rupak_bi  for the quick reply. I have some other thoughts to add:

 You can create a new measure to be placed on the visual object instead of the original measure, totaling the correct display.

 

New Measure = SUMX(VALUES('Table'[Deadline]),[Measure])

 

If the above one can't help you get the desired result, please provide some sample data. It is better if you can share a simplified pbix file. 

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

 

Best Regards,

Neeko Tang

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

kalspiros's avatar
kalspiros
Helper I
1 year ago

Hi Anonymous 

 

Thanks for your reply and providing these helpful pages.

In all honesty, I'm working on Excel.

I have just recreated the model in PBI but my original measure does not work as expected.

Therefore, I'm providing link to both files and I'd be probably more interested on exploring the .xlsx instead.

Your measure didn't quite work as expected I'm afraid.

 

Please feel free having a look and let me know if there's anything more I can do to assist.

 

forecasting.pbix

Forecasting_share.xlsx

 

Many thanks

 

Kind Regards