March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
Solved! Go to Solution.
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")
sorry for torturing this much, if I would like to add transparency format to your code line unichar (bottom of the actuals measure code)
....
Hi ! explain how to count the following measures
Margin%
EBITDA
EBITDA%
apologies,
margin % = margin / revenue
EBITDA = margin - other expenses
EBITDA % = EBITDA / revenue
BR
Petar
thats great 🙂 can you please share the solution (ege PBI file or codes)?
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...
awesome! is it possible to add additional ones (eg to make order 10) or this is all we can use?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
86 | |
83 | |
72 | |
49 |
User | Count |
---|---|
167 | |
149 | |
98 | |
73 | |
57 |