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...
eliasayyy's avatar
eliasayyy
Icon for Memorable Member rankMemorable Member
3 years ago

can you please show what the allexcept measure

  • 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