cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

Frequent Visitor

## Current month from year & month (format)

Hi All,

I have data like below table.

Source of data - Excel

Req -  calculate current year current month of A,B,C

 Month A B C 2021-00 0.200 0.900 0.650 2022-01 0.400 0.66 0.23 2022-02 0.200 0.900 0.650 2022-03 0.400 0.66 0.23 2022-04 0.200 0.900 0.650 2022-05 0.400 0.66 0.23 2022-06 0.200 0.900 0.650 2022-07 0.400 0.66 0.23 2022-08 0.200 0.900 0.650 2022-09 0.400 0.66 0.23 2022-10 0.200 0.900 0.650 2022-11 0.400 0.66 0.23 2022-12 0.400 0.66 0.23 2022-00 0.400 0.66 0.23

Thanks.

1 ACCEPTED SOLUTION
Resolver II

Hi @Smartnag ,

Here are the steps you can follow：
1. Create measure.

```Flag =
var _flag=
VALUE(
LEFT(MAX('Table'[Month]),4))
var _currentyear=
YEAR(TODAY())
return
IF(
_flag=_currentyear,1,0)```

2. Set [A], [B], [C] to Sum.

3. Place [Flag]in Filters, set is=1, apply filter.

4. Result:

Current month from year & month (format).pbix

Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

2 REPLIES 2
Resolver II

Hi @Smartnag ,

Here are the steps you can follow：
1. Create measure.

```Flag =
var _flag=
VALUE(
LEFT(MAX('Table'[Month]),4))
var _currentyear=
YEAR(TODAY())
return
IF(
_flag=_currentyear,1,0)```

2. Set [A], [B], [C] to Sum.

3. Place [Flag]in Filters, set is=1, apply filter.

4. Result:

Current month from year & month (format).pbix

Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Super User

<checks calendar> yup, normal years still have 12 months, not 13.   What does "2021-00"  mean in your context?

Announcements

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors