You’re offline. This is a read only version of the page.
New to Power BI and Power Automate (From SSRS) and have some questions if somebody could please help:
1. How can I test my expression outputs to see if they are valid/correct or not?
For example, I have a date expression in SSRS that is DateAdd("d",-1, today());. in SSRS I can clearly see when input that this gives midnight yesterday as the output. I'm thinking something like this formatDateTime(addDays(utcNow(),-1),'yyyy-mm-dd hh:mm:ss') but I have no idea if it returns what I need.
2. What's the best resource to learn how to format date queries in DAX? The Microsoft examples don't even cover the most basic practical examples.
3. Does power automate use some variation of DAX that has less functionality? e.g. I can see now() as an option in DAX in PBI desktop, but only UTCNow() exists in power automate
1. You can place the expression in a Compose action and see the output in the flow run.
2) All available expressions are accessible from the Expressions tab. You can create more complex expressions using additional actions (like regex, etc) or implement your own expression using a child flow.
Share
Report
74
All responses (
Answers (
