Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

YTD weekly calculation

Hi everybody, I have a measure to calculate the YTD (year to date, since 1st January) service availability of different business process. This measure is as follows:   YTD Weekly Availability = (...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi amitchandak 

    My mistake. Relationship between  Date Table and my date column was not OK. Now seems to be working .

    Thanks a lot amitchandak 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi amitchandak 

Thanks a lot , but it´s not working.

The measure is given me the Running Total up to now, but when adding to a visual a putting the weeks in the colum visual table , it keps giving the down time by week instead of the running total until each week.... so I have the same wrong calculation, YTD for each week not the running total YTD. 

Please see the difference between Power BI calculations and Excel calculations 

 

BR

 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi amitchandak 

My mistake. Relationship between  Date Table and my date column was not OK. Now seems to be working .

Thanks a lot amitchandak