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.
Hi there,
My main "fact" table is created with:
PowerBi Table: My Account Transactions
SELECT AccNumber,Amount, Description
FROM "LedgerTransactions"
WHERE DDATE >= DATEFROMPARTS(2018,01,01) //Limit Dates
I'd like to create a supporting table which is contrained by the Power bi table 'My Account Transactions'
PowerBi Table: Account Categories
SELECT AccNumber, MainCategory, SubCatergory
FROM "LedgerTransactions"
WHERE AccNumber IN (select distnct AccNumber from 'My Account Transactions')
Is this at all possible?
@michellepace , refer if this can help
https://www.excelguru.ca/blog/2016/04/28/pass-parameters-to-sql-queries/
In addition to the warnings in that great article you will also get into trouble with the Great Formula Firewall. There be dragons.
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.