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 everyone,
I've got the following data:
Datekey | Value |
20200101 | 1000 |
20200201 | 1000 |
20200301 | 1500 |
20200401 | 1500 |
20200501 | 750 |
20200601 | 1000 |
The timestamp is linked to a separate date table.
Based on that I currently have a chart with a running total (1000, 2000, 3500, 5000, ...) and a monthly value (exactly what is shown in the table above).
However, I would like to show the sum of the values for every month, based on the time-filter i'm using on the dashboard.
So let's say i'm filtering on Q1 2020. then in the chart I would want to see:
jan-2020 - 3500
feb-2020 - 3500
mar-2020 - 3500
How can I achieve that?
Solved! Go to Solution.
@Spekko
Your measure will have to be like:
Measure = Calculate ( sum(table[sales]) , allselected(Date[MonthYear])
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Spekko , create a date table move your qtr, month, year filter there. and then try a measure like example with month (from date table) and check
example
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[date])))
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
@Spekko
Your measure will have to be like:
Measure = Calculate ( sum(table[sales]) , allselected(Date[MonthYear])
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |