March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I want a calculated column that will return a customised column as shown in the snip below, so that when i use the column as a filter on my report, users can select current month to show details for the active month.
Many thanks for the assistance.
Solved! Go to Solution.
@Selded , In you date table you can have a column like
Month Type = Switch( True(),
eomonth([Date],0)= eomonth(Today(),0),"Current Month" ,
Format([Date],"MMM-YYYY")
)
or
Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"Current Month" ,
Format([Date],"MMM-YY")
)
Sort this on a column Format([Date],"YYYYMM")
Refer: https://www.youtube.com/watch?v=hfn05preQYA
@Selded , In you date table you can have a column like
Month Type = Switch( True(),
eomonth([Date],0)= eomonth(Today(),0),"Current Month" ,
Format([Date],"MMM-YYYY")
)
or
Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"Current Month" ,
Format([Date],"MMM-YY")
)
Sort this on a column Format([Date],"YYYYMM")
Refer: https://www.youtube.com/watch?v=hfn05preQYA
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
99 | |
90 | |
72 | |
62 |
User | Count |
---|---|
140 | |
121 | |
106 | |
98 | |
94 |