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.
Hi i'm calculating sales over month. with a year to date total column. it is working fine if there is sales for the current month but if there is no sales, it is not calculating for this month.
=CALCULATE (
[Sum of LINETOTAL],
FILTER (
ALL ( Query[MonthOrder] ),
Query[MonthOrder] <= MAX (Query[MonthOrder] )
)
)
ex of the result if there is no sales in november
order oct---YTD OCT---order nov---ytd NOV --- order dec--- YTD DEC
1000 5000 empty empty --- 1000 6000
what i want is to have 0 for order nov and 5000 for YTD Nov
hi @P-H ,
Seems doable but also strange. Try to pose some sample data, ideally with expected result.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
74 | |
51 | |
45 | |
16 | |
12 |