Forum Discussion

saiftv's avatar
saiftv
Frequent Visitor
6 years ago
Solved

create visualization that sum LOAD_MW for all grid_code and display today, yesterday and last year

Can anyone help me please, I’m new in power bi, On the table below I want to create visualization that sum all Load_mw for all grid_code for each R_Time for each day in R_date and to compare today l...
Need Help
  • saiftv's avatar
    saiftv
    6 years ago

    hi,

     

    it works, i used below calculate

     

    last_year =
    (CALCULATE(
        SUM ( GRID_LOAD[LOAD_MW] ),
        ALLEXCEPT ( GRID_LOAD, GRID_LOAD[R_TIME]),
        DATEADD( ( GRID_LOAD[R_DATE]), - 1,YEAR)))
saiftv's avatar
saiftv
Frequent Visitor
6 years ago

Hi mwegener

For the prev day is working fine, for the prev year it sum all previous year load_wm. I want something like this. Sum all load_wm of all grid_code for the hour 0.00, then for 1.00 and so on for today, and for yesterday and for the same date of last year.

saiftv's avatar
saiftv
Frequent Visitor
6 years ago

hi,

 

it works, i used below calculate

 

last_year =
(CALCULATE(
    SUM ( GRID_LOAD[LOAD_MW] ),
    ALLEXCEPT ( GRID_LOAD, GRID_LOAD[R_TIME]),
    DATEADD( ( GRID_LOAD[R_DATE]), - 1,YEAR)))