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.
Hi team, hope that someone would be able to help, the issue is related to power automate.
When i`m bringing in values from a related table, with the =related formula it works jsut fine
When i add an IF clause like =if('Output'[Month to Nr]=value("1").related('Input'[Business])."false") it gives me the error in the title. any idea how i could fix it? i have tried numerous variations.
EDIT : i tried the following as well : if('Output'[Month to Nr]=VALUE("1").value(related('Input'[Business]))."false") gives the same error.
Where have you seen syntax like this:
value("1").related('Input'[Business])."false"
???
This certainly is not DAX.
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
7 | |
6 |