Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance 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 |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
8 | |
7 |