Brilliant example and very timely for me! Thanks. I especially appreciate you walking through the steps that most of us would probably try. It's always frustrating to find a solution that works, until it doesn't. Cheers!
Hi Mitchell, great video! Makes all sense when learning more DAX and put it to use. I'm struggling with a data set: customer accounts with acc balance for each time a transaction was done... there may be 3 transactions in May (LASTNONBLANK works) but there may also be 0 transactions in June. Now the closing balance for June should be the same as after the last transaction in May. How can this be solved best using the DAX functions you presented?
It should be other way around. The All(‘Date’[Day]) would work. The ALLEXCEPT would give you numbers from last month for each day respectively which I guess in this scenario would be wrong
Hi, thanks for this. I have something quite similar but with mine it's a daily ending balance I'm after. Sometimes a day has multiple ending balances and sometimes there is no ending balance for the particular date if there was no transaction on the date. I've followed along closely to your video and don't understand why my formula errors. Can you help me? End of Day Balance:=CALCULATE( [Ending Balance], LASTNONBLANK( PARALLELPERIOD( GLI[Date], 0, GLI[Date]) , [Ending Balance]))
![Filter your Power BI Report to the last working date using DAX! [Two simple solutions] ❗](http://i.ytimg.com/vi/fb0_e9T2ZVo/mqdefault.jpg)
![Filter your Power BI Report to the last working date using DAX! [Two simple solutions] ❗](/img/tr.png)
Brilliant example and very timely for me! Thanks. I especially appreciate you walking through the steps that most of us would probably try. It's always frustrating to find a solution that works, until it doesn't. Cheers!
Glad it was helpful!
This was fantastic as usual! You always take on the sometimes difficult problems and are very thourough and clear the way you explain your approach.
Fantastic tutorial!! Thanks!!
You're very welcome!
Hi Mitchell, great video! Makes all sense when learning more DAX and put it to use. I'm struggling with a data set: customer accounts with acc balance for each time a transaction was done... there may be 3 transactions in May (LASTNONBLANK works) but there may also be 0 transactions in June. Now the closing balance for June should be the same as after the last transaction in May. How can this be solved best using the DAX functions you presented?
Tks for the excellent video!
By the way, what is the Dax Expression for the Close Price measure?
Where could we download the dataset? Thanks you!
What about using CALCULATE( [Close Price], LASTNONBLANK('Date'[Date], [Close Price],), ALLEXCEPT('Date'[Day]) ) ??? Would it be possible?
It should be other way around. The All(‘Date’[Day]) would work. The ALLEXCEPT would give you numbers from last month for each day respectively which I guess in this scenario would be wrong
What was the content in close price measure
Awesome!!
Thank Jihwan! Glad you liked it.
Good one Mitchell , now you can take your vacation:)
Thanks!
Hi, thanks for this. I have something quite similar but with mine it's a daily ending balance I'm after. Sometimes a day has multiple ending balances and sometimes there is no ending balance for the particular date if there was no transaction on the date. I've followed along closely to your video and don't understand why my formula errors. Can you help me?
End of Day Balance:=CALCULATE(
[Ending Balance],
LASTNONBLANK(
PARALLELPERIOD(
GLI[Date],
0,
GLI[Date])
,
[Ending Balance]))
sorry I meant to include thar when the date has multiple ending balances it's the last entry I'd like to return. Thanks!