Forum Discussion

angelina_tr's avatar
angelina_tr
Regular Visitor
2 years ago

Line chart

Hej, for some reason the curve shows the same values ​​for future months for which we have not yet entered data into the Excel. Even there are not even empty cells for this data    In the second pi...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Can you create a year to date column in your date table like I suggested, and use a ytd = 1 filter in your expression to sum values?

angelina_tr's avatar
angelina_tr
Regular Visitor
2 years ago
No, because have my data in Excel. And reverse the monthes
  • angelina_tr's avatar
    angelina_tr
    Regular Visitor
    2 years ago
     
    My data base in Excel look like this. I can't apply the logic with collunn that you suggested((
    Maybe you have some suggestion how I can do it? Becouse my monthes in is one line, like a titels, it's not a collumn. 

    I reverse to colluns it's already in PowerBI 
    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      If you unpivoted the date columns, you should be able to create this calculated column within your table:

      ytd_dates =
      IF (
      [Month] <= TODAY (),
      1,
      0
      )