Forum Discussion

David_IAO's avatar
David_IAO
Regular Visitor
3 years ago
Solved

Budget Three Years Columns

Hi,

 

im stuck somehow. im creating a visual from a sharepoint list. in this list, i have columns for: project title, group, budget this year, budget year +1, budget year +2, percentage, budget-percentage this year, ...

 

i would like to show the total budget for each year beside the budget-percentage so e.g. two columns beside each other for 2023, 2024, 2025.

 

is there a way to define that a whole column is connected to a year? my first idea was to create a new table and make two rows for each year but im stuck. could someone give me a hint?

 

 

Need Help
  • David_IAO's avatar
    David_IAO
    3 years ago

    i managed to create a Table.

     

    Table = 
    VAR _b = CALCULATE ( SUM('List'[This Year]))
    VAR _p = CALCULATE ( SUM('List'[This Year Percentage]))
    VAR _b2 = CALCULATE ( SUM('List'[This Year +1]))
    VAR _p2 = CALCULATE ( SUM('List'[This Year Percentage +1]))
    VAR _b3 = CALCULATE ( SUM('List'[This Year +2]))
    VAR _p3 = CALCULATE ( SUM('List'[This Year Percentage +2]))

    VAR re = { ("31.12.2023", _b, _p), ("31.12.2024", _b2, _p2), ("31.12.2025", _b3, _p3)}

RETURN
    re

1 Reply

  • David_IAO's avatar
    David_IAO
    Regular Visitor
    3 years ago

    i managed to create a Table.

     

    Table = 
    VAR _b = CALCULATE ( SUM('List'[This Year]))
    VAR _p = CALCULATE ( SUM('List'[This Year Percentage]))
    VAR _b2 = CALCULATE ( SUM('List'[This Year +1]))
    VAR _p2 = CALCULATE ( SUM('List'[This Year Percentage +1]))
    VAR _b3 = CALCULATE ( SUM('List'[This Year +2]))
    VAR _p3 = CALCULATE ( SUM('List'[This Year Percentage +2]))

    VAR re = { ("31.12.2023", _b, _p), ("31.12.2024", _b2, _p2), ("31.12.2025", _b3, _p3)}

RETURN
    re