Great as usual but I'll have to go through it a couple of times to work it out!

The meta magic is incredible! Just what I have been looking for. Thanks

Man! You are a freak of PQ. Thanks dude.

Excellent as always👍. Thanks James❤

Great tips!

You're a Meta Wizard 🧙🏽 🤟🏽

I have a card in Power BI showing the last value of a column in a date format. How can I make the background colour change if the date displayed is older than two days from today. I have clicked the FX button next to the background colour in the card formatting section, but it only allows some conditional formatting with a text option, no formula option. Thanks

@rauljimenez5485

Күн бұрын

You have to develop a measure that checks the condition and returns the hex color code that you want. E.g. if condition met then "#4B55W4" (here you place the color code you want)

The "meta" trick is very useful in some situations, but it should come with a big warning that if you add steps to the end of the query containing the "meta" statement, you have to manually cut/paste that part to the end of whatever the new "last step" is. Otherwise, any queries that depend on that meta step will break. Unfortunately, it isn't one of those persistent things that automatically updates the M code when you add more steps 😒

@adrianoschwenkberg6773

Ай бұрын

That's the reason why I prefer the record-replacement trick instead of using hardcoded meta step-value . Just replace the LET and the IN part with square brackets and voilà... your query keeps functional and you can reference each step you want from outside.

@larmondoflairallen4705

Ай бұрын

​@@adrianoschwenkberg6773 Ohhhhhh, that's the thing where you convert the whole query into one big record, right? I saw someone do that, and I was like, "Well, that's interesting, but I don't know what I would do with it." Thanks!!

@adrianoschwenkberg6773

Ай бұрын

@larmondoflairallen4705 for example as a container for your personal custom function collection...

nice workflow, thank you. may I give you an alternative way for this common typo-problem here kzread.info/dash/bejne/dImV3MqaY7acgtI.htmlsi=mgUNjhxXRUT5fo7Z&t=129 After autocomplete the functionname by pressing tab-key, then hold shift-key + Down-Arrow. Now you can type the open-bracket and the whole expression becomes wrapped arround the brackets and you dont even need to close it. Second note, i prefer to type functionnames by starting with the period-key. For example .Combine instead of Table.Combine. In that case you have less typing and the autocomplete dont mess with double-ing the text TableTable.Combine.

@larmondoflairallen4705

Ай бұрын

That is a handy tip. It will be a grand and glorious day when Microsoft finally fixes that infuriating "feature" that everyone complains about.