use DAX to create a new table or column

[Anonymous]

 I need to add two fileds, or may be a new table to be created

here is the original data,

I need  two column: sum(request_headcount) when month(sorted_onboard_date) = 202205 and 202205,

sum(request_headcount) when month(sorted_onboard_date) = 202204 ,202204

sum(request_headcount) when month(sorted_onboard_date) = 202205 ,202203

namely, I need to three values based on month(today) and return 2 columns to be shown to creat a visual:

month, sum(request_headcount)

202205           13

202204          23

202203          16

Do you have any ideas? Thank you.

[v-jingzhang · Accepted solution]

Hi @Anonymous 

If your purpose is to display a visual with month and sum(request_headcount) columns, you can first add a month column to the table with month = FORMAT('Table'[sorted_onboard_date],"yyyymm")

Then create a table visual to the report. Drag month and request_headcount to the table visual. Right click on request_headcount and select Sum for it. In the same way select Don't summarize for month. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[amitchandak]

@Anonymous , Do you need somhing like that

This Month Today =
var _min = eomonth(today(),-1)+1
var _max = eomonth(today(),0)
return CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

Last Month Today =
var _min = eomonth(today(),-2)+1
var _max = eomonth(today(),-1)
return CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

refer

https://medium.com/chandakamit/cheat-sheet-power-bi-time-intelligence-formulas-using-today-654f26e27304

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