Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)

I am using data that exactly looks like this:

DATE       | VALUE
01/01/2011 | 100
02/01/2011 | 150
02/01/2011 | 550       

I want calculated measure with values within a date range with DAX Syntax

consuntivo = CALCULATE(SUM(provadat[valori]);provadat[datazione]>=DATE(2015;01;01)&&provadat[datazione]<=DATE(2016;01;01))  

But i am getting which i am not expecting

enter image description here

So any help regrading it? 

1 Answer

0 votes
by (22.5k points)
edited by

Use this DAX expression

consuntivo = SUM(provadat[valori])

Want to learn more, then enroll in the Power BI Course

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Mar 28, 2021 in BI by Chris (11.1k points)
0 votes
1 answer

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...