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.
New to Power BI. Let me try to explain my question. I have connected to a LIVE database and want to create a table that only shows rows if a cell that contains some date is more recent than another date in a different cell in the same row. By more recent I mean let's say one cells says 10/01/2021 and another 02/10/2023, then I want this row to be displayed. But if the latter is older than the former then it shouldn't be displayed. Hope it makes sense. Please help!
you cannot add columns to live connection data sources. But you can convert these to Direct Query with local model. Then you can add your columns and use them as filters.
User | Count |
---|---|
77 | |
76 | |
36 | |
31 | |
29 |
User | Count |
---|---|
93 | |
79 | |
57 | |
48 | |
48 |