Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a measure that does a calculate of a sum of revenue in a sales table on filtered ledger accounts.
I use a date table with date, quarter and year. The date has a relationship with the date of sales of the salestable.
Then I created a second measure, that calculate's the first measure on the year in the datetable:
Omzet HJ = CALCULATE(
[Omzet],
FILTER(ALL(Datumtabel), Datumtabel[Jaar] = YEAR(TODAY()))
Solved! Go to Solution.
Hi,
I am not sure if I follow but you want to have the calculation on a monthly basis? Now your ALL removes all the filters from your datetable. Afterwards you specify that the year in you calculation needs to be this year, but you don't define the month filter context back. Try this: ALL(Datumtabel[jaar]). This will only remove the year context. For LY you can use YEAR(TODAY())-1 in the measure. One alternative way to do this is to add month selection to your FILTER e.g. Datumtable[Maand]=MAX(Datumtable[Maand]).
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Proud to be a Super User!
Hi,
I am not sure if I follow but you want to have the calculation on a monthly basis? Now your ALL removes all the filters from your datetable. Afterwards you specify that the year in you calculation needs to be this year, but you don't define the month filter context back. Try this: ALL(Datumtabel[jaar]). This will only remove the year context. For LY you can use YEAR(TODAY())-1 in the measure. One alternative way to do this is to add month selection to your FILTER e.g. Datumtable[Maand]=MAX(Datumtable[Maand]).
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Proud to be a Super User!
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
23 | |
10 | |
10 | |
9 | |
7 |