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.
I am new to this forum and am power bi, desperately looking for DAX where. Please help!! Thanks in advance
I have 2 tables: Table 1 and Table 2, when Dates are added then the ID(3 and 4 below case) disappears from Table2 now I need to count how many move from table 2 to table1.
Table1
ID Titles PlannedDate ReleaseDate Path
3 Test3 6/1/2021 6/1/2021 Case1
4 Test4 8/1/2021 null Case1
Table2
ID Titles PlannedDate ReleaseDate Path
1 Test1 null null Case2
2 Test2 null null Case2
3 Test3 null null Case2- (Case1)
4 Test4 null null Case2- (Case1)
5 Test5 null null Case2
Solved! Go to Solution.
Ended up adding another column to the table to recognize the move. I couldn't implement it on Power BI but the extra column(checkbox) helped.
Ended up adding another column to the table to recognize the move. I couldn't implement it on Power BI but the extra column(checkbox) helped.
You cannot with the info you have given. When Power BI refreshes, it deletes the entire model and recreates it, so it doesn't know records "moved" from one table to another. (That isn't actually what it does - over simplification, but the point stands).
The only way you can count the records would be one of the following:
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering 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 |
---|---|
100 | |
51 | |
19 | |
12 | |
11 |