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 ...
Need Help
petar_kisdobran's avatar
petar_kisdobran
Frequent Visitor
3 years ago

apologies,

margin % = margin / revenue

EBITDA = margin - other expenses

EBITDA % = EBITDA / revenue

BR

Petar

Ahmedx's avatar
Ahmedx
Super User
3 years ago

  • petar_kisdobran's avatar
    petar_kisdobran
    Frequent Visitor
    3 years ago

    thats great 🙂 can you please share the solution (ege PBI file or codes)?

      • petar_kisdobran's avatar
        petar_kisdobran
        Frequent Visitor
        3 years ago

        thanks! 
        Could you please help me understand how have you managed to enter a space character in DimLine data (line # 7) and that PBI accept this as unique value compared to a blank row (line # 5)? If i try to add another 2x space character (eg line #10), PBI recognised it as duplicated value so I cannot do one->many relationship and your other solutions...