User Profile
Matt_HD
Frequent Visitor
Joined 6 years ago
User Widgets
Contributions
Creating and storing snapshots of a table in the data model
Hi I have a pbix file that pulls data from a couple of sources and brings together a mart table that i create a number of measures and visuals from. I'd like to track this over time and the transactional data doesnt support this. My idea is to create a snapshot of this table daily (ie freeze it in time with a datestamp on each row) and store it in a snapshot table, the following day/week/period etc the model would create another snapshot and add it to the snapshot table and repeat ad infinitum. Is this possible in the data model? if so does anyone have any examples or ideas please? (Ive had a team previously do this for me in sql in a data warehouse in a previous life but the company im working for at the moment are very resource light so its only a PowerBI model in the service at the moment)1.8KViews1like1CommentCreate a snapshot of a table on a series of specified dates.
Hi I have a PowerBI data model that has one particular table (made up of source data with some calculated colums) that i'd like to create a snapshot of on specified dates and store in the model. I'd like all the snapshots to be in one table with a datestamp. Is this possible?878Views0likes2CommentsConvert Conditional CountIFS from Excel to DAX , help please
Hi I have the following excel formula =IF( [@[Is Standard]]=FALSE, COUNTIFS([Programme],[@Programme],[Framework/Standard Title],[@[Framework/Standard Title]],[Overall cohort year],[@[Overall cohort year]]), COUNTIFS([Framework/Standard Title],[@[Framework/Standard Title]],[Overall cohort year],[@[Overall cohort year]]) ) Assume its all in one table (Table1) how do I write this as a measure? Thanks in advance760Views0likes2CommentsRe: Measure works on rows but not subtotals in Matrix
Hi, that doesnt work im afraid as it just adds up all the % ages into a total, the answer should be 55% and that gives 2241% I need it to apply the same calculation to the subtotals/totals as the rows, not add up all the rows calculations.709Views0likes0CommentsMeasure works on rows but not subtotals in Matrix
Hi I have some data (all on one table) that i'm summarising in a matrix The table is as follows ( other columns redacted) there are many rows and the name is 'CTS Budget Course Volume' Course Value Budget Total Attendees Trainer Ratio Capacity per Course Date H&S 20 9 1 20 01/04/2020 The manual calculation for Occupancy would be [Budget Total Attendees] / [Trainer Ratio] x [Value] x [Capacity Per Course] I have converted to DAX as follows Occupancy Budget (%) = DIVIDE( SUM('CTS Budget Course Volume'[Budget Total Attendees]), SUM('CTS Budget Course Volume'[Capacity per Course])*sum('CTS Budget Course Volume'[Trainer Ratio])*sum('CTS Budget Course Volume'[Value]) ) However on a matrix visual this works perfectly for individual courses, but I have a Date Row and the subtotals/totals dont work properly......they display 0% Any ideas? There is a course master and date master table in the model with a simple 1 to many retalionship back to this table and this works fine accross the reso of the model so I suspect my issue is with the DAX above. Thanks for your help742Views0likes2CommentsUso del informe de Salesforce como fuente de datos
Hola Estoy usando (planea usar) un informe de Salesforce como fuente de datos, lo que no sé es que necesito actualizar el informe en Salesforce a medida que se producen más transacciones para que los datos se actualicen en mi informe o que ocurra sin que tenga que volver a tocar salesforce?Solved1.1KViews0likes3CommentsUsing Salesforce report as a data source
Hi Im using (plan to use) a Salesforce report as a data source, what i dont know is that do i need to refresh the report in Salesforce as more transactions happen for data to refresh in my report or will it just happen without me having to touch salesforce again?Solved9.5KViews0likes4CommentsRe: Resumir una tabla Grupo por una columna filtrando otra columna un estado y otra por el valor máximo
Hola sólo para aconsejar ninguna de estas soluciones funcionó mi resolución era traer la misma tabla de nuevo con algunos filtros en la consulta para darme un conjunto de datos redactado, luego creé una columna auxiliar y pude crear la nueva tabla que necesitaba con esto. No es particularmente elegante, pero hizo el trabajo por ahora.631Views0likes0CommentsRe: Summarize a table Group by one column filtering another column a status and another by the max value
Hi just to advise none of these solutions worked my resolution was to bring in the same table again with some filters on the query to give me a redacted data set, I then created a helper column and could create the new table I needed with this. Not particularly elegant but got the job done for now.1.2KViews0likes0Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.