Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I have a table that contains daily balances for several accounts by date. It doesn't have an entry for every date.
The user selects a date they are interested in, I would like to display each account by value on a Clutered bar chart.
I am trying to create a measure that will calculate a value. If the an entry doesn't exist for the selected date I would like the value of last entry before the selected date.
This is what I have so far but is giving me the error max has been used in a true/false expression that is used as a table filter
[Total Value] is a measure I have created and just totals the closing balance field.
here is my model
thank you for all help
Solved! Go to Solution.
Here is one approach to do it. I made a mock table called Table that doesn't have balances for every date, and a Date table that has all dates.
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Here is one approach to do it. I made a mock table called Table that doesn't have balances for every date, and a Date table that has all dates.
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
I get the following error when attrmpting this:
The value for 'Total' cannot be determined. Either the column doesn't exist, or there is no current row for this column.
Do I have something in the wrong location or am I missunderstanding something?
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |