Forum Discussion

chrisw888's avatar
chrisw888
Frequent Visitor
3 years ago

Function for considering time active and inactive

Hello,    Would anyone be able to assist me with my issue? I have four columns of data that looks like the below picture.   I am trying to show a table as follows using this data (note that c...
chrisw888's avatar
chrisw888
Frequent Visitor
3 years ago
Hi 
 
Sure
 
Site Power = CALCULATE(SUM(Aging[Power kwh]),ALLEXCEPT(Aging,Aging[Site]))
 
Aware its not really correct, it had worked for me for most of what I am looking to do. Its only when I got to this stage i noticed it doesnt consider these sorts of situations where the site has changed.
eliasayyy's avatar
eliasayyy
Icon for Memorable Member rankMemorable Member
3 years ago

ok now please explain dataset and what are you trying to achieve if its no issue like is their sny relationships , are all in in 1 table...

 

  • chrisw888's avatar
    chrisw888
    Frequent Visitor
    3 years ago

    My ultimate goal is to get to power utilisation %. I have a secondary table that is linked via site name, and this table gives me the kwh actually used. The table above is really to calculate the total kwh available at the site each day.

     

    Once i can get the power available each day and the power used each day, i will divide the power used by power available.

     

    Realistically I want to show the % per site on a monthly basis, not daily, though this should be a matter of dropping out the day in date hierarchy when it comes to charting it on a line.

     

    Bit of a head scratcher, I am still new to writing my own DAX. Long time user in excel, but trying to write this analysis into Power BI

    • eliasayyy's avatar
      eliasayyy
      Icon for Memorable Member rankMemorable Member
      3 years ago

      ok can you please share a sample of your dataset if its not an issue?

      and you shared 2 tables the first one is the kw consumption per site? why is their multiple dates? for example in site B and why is there no decommission date

      • chrisw888's avatar
        chrisw888
        Frequent Visitor
        3 years ago

        Sadly I dont think I have the function to add an attachment on the forums yet 😞