Invoice Checking for automation purposes
Hi PBI Community I want to create a DAX measure which returns a "✓" when the invoice amount posted is equal to the same as the previous journal entry posting. and a "✗" when the invoice amount is different. It needs to be conditional on the Amount being posted to the same G/L Account ID and the same Vendor Name. I made the following, but it doesn't consider the element of previous journal entry posting or whether it is the first posting for that Vendor and related G/L Account ID. Automation Check = if(ISBLANK([TY (EUR)]), blank(), IF(CALCULATE([TY (EUR)] / [€ Avg.]) = [# Postings], FORMAT("✓", "Green"), FORMAT("✗", "#Red") )) How could I change it so that the measure returns "x" when it is first postings as well, and not only compares total amount / avg. posting = count of postings. The matrix visualization looks like this right now:
Is there any way to automate or speed up bulk creation of similar DAX measures?
Hello! I have to create many (nearly identical) DAX measures that work in the same way, but will change as they are created to apply to a series of different columns. My current process is just to copy and paste the template formula and change the column names accordingly. This is a bit tedious though. I was thinking it would be nice if users could design their own Quick Measure to add to those offered in Power BI desktop. If anyone knows of a way to do this or to otherwise quickly create very similar measures, please let me know! For reference my calculation goes generally like this: Measure = (CALCULATE(SUM(Table1[Column1]), FILTER(Table1,Table1[Column2]="x"))) / (CALCULATE(SUM(Table1[Column1]), FILTER(Table1,Table1[Column2]<> BLANK() ))) Each time, for varying purposes, I have to change "Column2", and/or "x", and/or "Table1". The closest thing that Quick Measures has would be the "Division" quick measure, but doesn't quite work because of the filters. If anyone knows of a way to automate or otherwise very quickly create very similar measures, please let me know! Thank you!
