cancel
Showing results for
Did you mean:
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

#### 2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

#### Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

#### 2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors