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 am using measure to calculate profit across the dates.
This is the data that I am using. Date, Revenue on that date and Cumulative revenue.
Cumulative value even when I choose a particular filter comes correct as per the overall amount.
e.g.,2018 data.
But I would like to plot this on a clustered column chart so I need cumulative sum on all the days.
I use :
Solved! Go to Solution.
Hi @shubh25 ,
One sample for your reference, please check the following steps as below.
1. Create a calendar table as below and make it related to the fact table.
CALENDAR = CALENDAR(DATE(2019,01,01),DATE(2019,01,31))
2. To create a measure.
Measure = CALCULATE(SUM('Table'[Revenue]),FILTER(ALL('CALENDAR'),'CALENDAR'[Date]<=MAX('CALENDAR'[Date])))
Hi,
What is the difference between the 3rd and 4th Table?
Hi @shubh25 ,
One sample for your reference, please check the following steps as below.
1. Create a calendar table as below and make it related to the fact table.
CALENDAR = CALENDAR(DATE(2019,01,01),DATE(2019,01,31))
2. To create a measure.
Measure = CALCULATE(SUM('Table'[Revenue]),FILTER(ALL('CALENDAR'),'CALENDAR'[Date]<=MAX('CALENDAR'[Date])))
I am trying to do that already. However, rest of the filters are in another table i.e., "Finacials". Is there a way that I can use all and selectedvalue on columns from different tables.
i.e., DATES from CALENDER & SOURCENAME from FINANCIALS.
The DAX expression I am currently using-
I would use GENERATESERIES to create a new table with all of the dates you need, or just CALENDAR or CALENDARAUTO perhaps. Then you could use that as your axis.
Generating all dates for all the data set will create millions of rows which will slow down the pbix significantly.
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |