Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |