Forum Discussion
cbolling
Helper I
Helper ICreate a Rolling Month Filter given a date filter
I have a graph that plots revenue. I need a filter that filters the dates on the graph to show only the current month depending on the selected date. The graph should be a rolling month. If the s...
amitchandak
Super User
Super Usercbolling , with help from a date table use datesmtd
example
MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA
cbollingHelper I
Helper IHi amitchandak ,
I do not want to display MTD sales, I want to display sales of each day in the month, but the X axis is the day of the month, and next week on the first day it would jump back to 1.