Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
89 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |