The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Need a help for the below ...
I have the below data in a table with 2 columns ...imported from an excel file... ( No sql server etc, but using excel import as powerbi dataset)
Now a simple report I want as a powerbi dashboard view, which will need to show the additions and deletions ... basis feb22 rows vs Jan22 rows...
Needed output like this...
Added
XYZ
Deleted
ABC
JKL
BASE DATE in table...
Jan22 ABC
Jan22 DEF
Jan22 GHI
Jan22 JKL
Feb22 DEF
Feb22 GHI
Feb22 XYZ
HI @HariPower,
Did these records directly replace and update your data source or append after original records?
If you mean the first one, current power bi does not include historical data analysis feather to cache history data and compare it with current records.
If you mean the second one, you can use the date as the group to filter records, then you can use except function to get the different records.
EXCEPT function (DAX) - DAX | Microsoft Docs
Regards,
Xiaoxin Sheng
@HariPower , refer my customer Retention, that can help. You can create a date using the month year if needed. here you can use a count or a column as a measure (sales/net in blog). Customer is your second column
Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/b...
HI Amit, using your customer solution, I could implement what is required. Just took example of 3 measures from your implementation, worked around and done. Thanks for guidance...
Thanks Amit, checking your report if that implementation suits my purpose...one thing sure I understood is that dates table should be part of my ask to enable what I want...thx
User | Count |
---|---|
10 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
22 | |
14 | |
14 | |
9 | |
7 |