custom formula

2 Topics

2 Measures on same line graph
I have 2 rolling 14 day average calculations and Im hoping to display them (highlighted) on the same line graph: However I've tried to create a date bridge and another table to relate to and still no luck with either approach. Where it should look more like this: Can anyone help with this? SEE FILE ATTACHED https://www.dropbox.com/s/ksi9fm0kbzpj1hg/Notification%20vs.%20Epi.pbix?dl=0
Anonymous
5 years ago Place DAX Commands and Tips
917Views
0likes
1Comment
Use results from a card in a custom calculation for another card
I'm a new user of Power BI and this is my first post so hello everyone! I work for a property company and am creating a dashboard to show property values, capex and Return-on-Equity at each half year period. The user can select specific properties or the whole portfolio through various slicers. Unfortunately I can't share the data as it is commercially sensitive however it is broadly set out as follows: Property Period (in date form in my data) Attribute Value Buckingham Palace H2 2019 Valuation 100 Buckingham Palace H2 2019 CapEx spent 10 Buckingham Palace H1 2019 Valuation 90 Buckingham Palace H1 2019 CapEx spent 5 ... ... ... ... I have three cards set up as follows which depend on the selection within the slicer: Value at start - This shows the sum of all valuations on the earliest date. CapEx spent to date - This sums all capex spent in all periods. Current value - This shows the sum of all valuations in the most recent date. I want to create a fourth card which will display the profit to date: Result = Current Value - (Value at Start + CapEx spent to date) The problem is that I need it to be dynamic and adjust depending on the selection of the slicers hence why I would like to take the card results rather than calculate a new table of results. Is this possible?
Solved
FrankProperty
6 years ago Place DAX Commands and Tips
1.3KViews
0likes
3Comments