Jim Youmans
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
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.