Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I'm a new user, so bear with me:
I have a pretty simple data set in Table B that has data for when each ID is expected to receive revenue. It looks like this:
So there can be multiple rows for each ID. I want to create a new column in Table A (which has only one row for each ID) that brings the total income for each project when the date is today or earlier.
I tried this, but it is bringing me the same value for all IDs:
@ozturkk
Please try this:
Bugüne Tahmini Gelir =
VAR __Date = TODAY()
RETURN
CALCULATE(
SUM(TableB[INCOME]),
TableB[Date] <= __Date
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thank you for your reply. Sadly, I am still getting the same value for all IDs
l have also tried this to no avail:
SUMX( VALUES('TableB'[ID]), CALCULATE( SUM('TableB'[INCOME]), 'TableB'[DATE] <= TODAY(), 'TableB'[ID] = EARLIER('TableB'[ID]) ) )
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |