Forum Discussion

petar_kisdobran's avatar
petar_kisdobran
Frequent Visitor
3 years ago
Solved

Table with predefined form with multiple measures in columns

Hi everyone,

 

Can I kindly ask you to help me with following challenge, i have two tables, one with actual data and other with budgeted.

I appended them to have data in one query, and tried with measures (calculate function) to get needed outcome (snip below), however cannot make it in the form required (managed to get only actuals or budgeted amounts in required form, cannot add them both in one table)...

 

table actuals                                          table budgeted

            

 

Need to have

Measures used: revenue act = calculate(sum('actuals'[Amount act]),'actuals'[Line]="Revenue")

same for CoS and other expenses.

Margin act = [revenue act]-[CoS act]

same made for budgeted amounts, however could not present them side by side in table....

 

Thank you in advance!

 

My best,

Petar

 

 

 

Need Help

10 Replies

  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago

    You can add any character and apply conditional formatting to its font color. for example make it transparent

    CF = IF(SELECTEDVALUE(DimLine[Line])=UNICHAR(152),"#3E4AFF00")
    • petar_kisdobran's avatar
      petar_kisdobran
      Frequent Visitor
      3 years ago

      sorry for torturing this much, if I would like to add transparency format to your code line unichar (bottom of the actuals measure code)

      ....

        "", "",
          UNICHAR ( 160 ), "",
          FORMAT ([Act],"#")
      )
       
      and to change it for instance to Unichar (130),"", is it possible to add an transparency format to that line ?
      eg
      ....
      format (unichar130),#3E4AFF00",
      FORMAT ([Act],"#")
      )
       
      Thank you so much for all!
       
      My best,
      Petar
       
       
       
  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago

    Hi ! explain how to count the following measures
    Margin%
    EBITDA
    EBITDA%

    • petar_kisdobran's avatar
      petar_kisdobran
      Frequent Visitor
      3 years ago

      apologies,

      margin % = margin / revenue

      EBITDA = margin - other expenses

      EBITDA % = EBITDA / revenue

      BR

      Petar