Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Nicky_12345
Frequent Visitor

Sum of billed quantity for a particular month and year

Hi,

The below measure were created for sum of billed quantity for 2021 and 2022. Please advise how to create a measure for sum of billed  quantity for July 2022 and then another measure for August 2022. Thanks!

 

Billed Quantity 2021=
    CALCULATE(
        SUM('Append1'[Billed Quantity]),
        'Calendar'[Date].[Year] IN { 2021 }
    )
 

 

Billed Quantity 2022=
    CALCULATE(
        SUM('Append1'[Billed Quantity]),
        'Calendar'[Date].[Year] IN { 2022 }
    )

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

You can "pile on" filters

 

Billed Quantity August 2022=
    CALCULATE(
        SUM('Append1'[Billed Quantity]),
        'Calendar'[Date].[Year] = 2022 ,
        'Calendar'[Date].[MonthNo] = 8
 
    )

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

You can "pile on" filters

 

Billed Quantity August 2022=
    CALCULATE(
        SUM('Append1'[Billed Quantity]),
        'Calendar'[Date].[Year] = 2022 ,
        'Calendar'[Date].[MonthNo] = 8
 
    )

Thank you so much! 🙂

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.