Link to home
Start Free TrialLog in
Avatar of Jim Youmans
Jim YoumansFlag for United States of America

asked on

Show month to month growth in Power BI

This should be simple but I am really having trouble with it.  I have a table that records the size of a database, by table, each Sunday.  So the table looks like this...


TableName   Rows   SizeMB   DateRecorded

Open in new window


and I have entries going back to Aug of 2017.  I want to create a Power BI report where I can select a given table and see the growth (or decline) of the table size either week by week or month by month.  This should not be hard but it is eluding me.  Any suggestions?

Avatar of Tom Farrar
Tom Farrar
Flag of United States of America image

Something like this would give you a running total:
tot
CALCULATE([Total Sales], FILTER(ALL('Calendar'), 'Calendar'[Date]<=MAX('Calendar'[Date])))

You would have to sub table size for total sales.  This also assumes you have a Calendar table.
ASKER CERTIFIED SOLUTION
Avatar of Tom Farrar
Tom Farrar
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial