Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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.
@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
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
User | Count |
---|---|
106 | |
85 | |
81 | |
73 | |
71 |
User | Count |
---|---|
111 | |
102 | |
97 | |
74 | |
67 |