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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
manojk_pbi
Helper III
Helper III

help required to write Measure

Hi 

 

I am writing a meaure to calculate %Change from Dec'23 to Mar'24 and display value on card. Using the below measure.

Along with this KPI, i have few more KPIs on the same report which will use the filter of the ReportingMonth. 

 

I want below expression should not filter based on selected reporting month and do the calculation just by using reporting month value and defined values from preMY.

 

%Change_CYCM =
VAR _preMY = VALUE("2023-12-01")
VAR _preqty =
CALCULATE (
SUM ( 'Bugs'[BUGS_COUNT] ), FILTER(ALLSELECTED('Bugs'),
'Bugs'[ReportMonth]=_preMY)
)
VAR _curMY = VALUE("2024-03-01")

VAR _curqty =
CALCULATE (
SUM ( 'Bugs'[BUGS_COUNT] ),
FILTER (
ALLSELECTED ( 'Bugs' ),

'Bugs'[ReportMonth] = _curMY
)
)
RETURN

DIVIDE ( _preqty-_curqty, _preqty )

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Instead of 

 

VAR _preMY = VALUE("2023-12-01")

 

use

 

VAR _preMY = dt"2023-12-01"

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

Instead of 

 

VAR _preMY = VALUE("2023-12-01")

 

use

 

VAR _preMY = dt"2023-12-01"

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.