How to measure the decrease or increase by newest date

[mehlenbae2]

I am trying to measure the total increase or decrease of virus count by month by Configuration Item but I am unable to do this because the Virus Count is in one column and I have hundreds of thousands configuration items. I am hoping to put this in a line chart on PBI.. How can I do this easily? I am not that great with DAX.. Virus counts can increase and decrease anytime and I want to do see it all in one large line chart. Is this possible?

Here is my dataset:

[v-rzhou-msft · Accepted solution]

Hi @mehlenbae2 ,

Here I create a sample to have a test.

Tables:

Calendar = ADDCOLUMNS(CALENDARAUTO(),"Year",YEAR([Date]),"Month",MONTH([Date]))

Relationship:

Measure:

Difference = 
VAR _CURRENT = CALCULATE(SUM('Table'[Virus Count]))
VAR _PREVIOUS = CALCULATE(SUM('Table'[Virus Count]),PREVIOUSMONTH('Calendar'[Date]))
RETURN
_CURRENT - _PREVIOUS

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@mehlenbae2 , the expected output is not clear. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

I think these can help

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA
Power BI — Qtr on Qtr with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
https://www.youtube.com/watch?v=8-TlVx7P0A0
Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8
Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...