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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
jyaul786
Helper II
Helper II

Sum by year

Dear Friend,

i have two tables, data(value,id,..) and calendar(date,year,quarter) and are related one to many .

i have date slicer between and calculated profit by measure:

var date_min=CALCULATE(min('Calendar'[Date]),ALL('Calendar'[Date]))
var date_max=CALCULATE(MAX('Calendar'[Date]))
return
CALCULATE(SUM(JDT1[Value]),DATESBETWEEN('Calendar'[Date],date_min,date_max))
its working fine on any visual with category axis.But when i show visual with x axis Year,Quarter. its give wrong data.
could you please help how i can short out.
1 REPLY 1
whitch
Resolver I
Resolver I

This bit is not behaving as you're expecting:

ALL('Calendar'[Date])

It only removes filters directly applied to that column.  If the quarter or year columns are filtered, it will do nothing.  I recommend replacing it with ALL('Calendar').  You are not alone in having this issue.  Here's someone else having a similar problem:

https://community.fabric.microsoft.com/t5/Desktop/Cumulative-sum-with-Date-Hierarchy/m-p/797893

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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