Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))
I have matrix with Contact name, Total sales and Difference in % for Current and Previous Month columns , As I dont have date coulmn in matrix I have added a date filter in the Visual level , But previousmonth is not working as expected?
@PowerBITesting
Can you provide a sample pbix without sensitive data? That is the most straight forward for us to understand your model.
Regards
Paul
@PowerBITesting No real surprise there, T"I" functions become more of a hassle than a help if not used in very specific ways.
You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
Would need sample data and expected output to b specific.
User | Count |
---|---|
85 | |
80 | |
77 | |
49 | |
41 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |