Updown Monthly

[karinafreitass]

Hi,
Could someone help me? Please!

I would like to update the monthly variations and I would like to demonstrate in a panel, only the variation of the current month.

My measure for calculating the variation is ok: 

Total Crédito (% MoM) = DIVIDE([Total Crédito]- [Total Crédito (Mês Anterior)],[Total Crédito (Mês Anterior)],0)

The tables I have are:

Thank you in advance,

Karina

[karinafreitass]

@amitchandak thanks for your return.

I'm sorry for the lack of clarity, my English is not good and I'm a beginner in Power BI, I still have a lot of difficulty.

I would like to make a comparison between the months and identify the variation between them.

[amitchandak · Accepted solution]

@karinafreitass , You need to create formulas as I shared in the last update.

For Icon, you can use conditional formatting.

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e

also refer

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

[amitchandak]

@karinafreitass , Nor very clear. You want to create a measure a column.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

In case you need measure you can use time intelligence with date table

example

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))
this month =MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH('Date'[Date])))
last MTD (complete) Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-1,MONTH))))
previous month value = CALCULATE(sum(''Table''[total hours value]),previousmonth('Date'[Date]))

diff = [MTD Sales]-[last MTD Sales]
diff % = divide([MTD Sales]-[last MTD Sales],[last MTD Sales])

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi


Appreciate your Kudos.

[karinafreitass]

@amitchandak I'm trying to share the pbix file

https://ufile.io/dq98sj3l

[karinafreitass]

@amitchandak I will check and make some attempts.