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 All,
Please help me in this issue. I have a month slicer where I can select only one month. I would like to create a measure (onto a card visual), which shows me the sum amount from the past 2 month + the selected month. So if I choose 2019 June, I want to see the sum of amounts from 2019 April, May and June! I use now the following measure but it shows me only the selected month's amount..:
I believe this should work for you.
Measure = VAR period = DATESINPERIOD('Date'[Date];LASTDATE('Date'[Date]);-2;MONTH) CALCULATE( sum(GLEntry[Amount]); ALL('Date'); GLEntry[New Main Group] = "Net Sales"; Period )
Hi @tex628 ,
Many thanks it worked!
One more question please, it's the same issue but with one more difficulty..
I try the following measure:
Yes it works on it's own! Just if I put it into the Calculate function it's shows only the selected month value not the sum of the last 3 month.. Any idea?
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |