Power BI Report Server Dashboard Usage Stats
I'm interested in learning how to generate usage statistics, such as user logins, dashboard visit counts, and least-viewed screens. Could anyone please guide me through the process of creating an execution log or utilizing existing data to develop a Power BI report for publication on the Report Server web portal? Additionally, is it possible to automate the generation of these usage reports?
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:
Automated row for averages in Power Query
Hi there, so my question is that in power query is there a way for me to get a new column that shows the average of values in a row? The number of columns will be updated on a daily basis. So, would need the average column to be updated on a daily basis. For eg: We have a table here, say just 4 columns of data as of now and 5th column being average of 4 columns on a row wise representation. What if tomorrow, another column comes in between Jan 4 & average column. I need a way for it to automate this and give me row wise data whenever a new column is added. This image is just an example from normal excel, but my data is processed in Query, of course can't show the photo since data is sensitive. Once processed within Power query, I have it loaded into a Pivot table. So, it makes crucial for me to have data set in exact same format. what can be done?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!
