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
angelina_tr's avatar
angelina_tr
Regular Visitor
2 years ago
Good question! I replase it with "today"
But now my curve looks like a line ande include future monthes. I have no idea why 
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
        )