Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Forecast by using start date and end date issues

Hi everyone,      I created three dashboards for forecast related by using start date and end date...  1. I created one temp table for  calender it may gets max and min of start date and end date t...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    Modify your measure as below:

     

    _Sum of all months = IF(ISINSCOPE('Calendar date'[Date].[Month]),Tests[Total Amount]/12,SUMX(ALLSELECTED('Calendar date'[Date]),Tests[Total Amount]/12))

     

    And you will see:

    For the related .pbix file,pls click here.

     

     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

Modify your measure as below:

 

_Sum of all months = IF(ISINSCOPE('Calendar date'[Date].[Month]),Tests[Total Amount]/12,SUMX(ALLSELECTED('Calendar date'[Date]),Tests[Total Amount]/12))

 

And you will see:

For the related .pbix file,pls click here.

 

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous 

    Thanks a lot for your help