Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hallo,
There is a table with cash balances by day at the end of the day.
This table skips weekends when the balance of money does not change, and I need the missed days to be filled in as well.
I have tried joining this table with the calendar table with this:
But as a result, the weekend is still missed.
What can be done with DAX or M ?
Solved! Go to Solution.
Thanks a lot, I have modified your formula and its works as required:
@roman_gorbunov Create a table visual with Calendar[Date] in the table and add a measure:
Value =
_lastsaledate = MAXX(FILTER(ALL(cashbalancetable), cashbalancetable[date] <= calendar[date]), cashbalancetable[date] )
RETURN
MAXX( FILTER(ALL(cashbalancetable), cashbalancetable[date] = _lastsaledate, cashbalancetable[balance_sum] )
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
@roman_gorbunov , try last non Continuous with help from date table
Last Day Non Continuous = CALCULATE([sales],filter(ALLSELECTED('Date'),'Date'[Date] =MAXX(FILTER(ALLSELECTED('Date'),'Date'[Date]<max('Date'[Date])),'Date'[Date])))
or
CALCULATE(lastnonblankvalues( 'Date'[Date], [sales]) ,filter(ALLSELECTED('Date'),'Date'[Date] =MAX('Date'[Date] ) ) )
or
Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...
Thanks a lot, I have modified your formula and its works as required:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |