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,
I need to present data in form of curr month -1 , curr month and curr month +1
Below is the dataset containing sales of prev month curr month and curr+1 month (predicted)
I want the data in to represent in the below pic in a table format in powerbi
Can someone help me with dax of curr month -1 , curr month and curr month +1 .
Thanks
Shreyd22
Hi mlsx4,
Thankyou for your response . But the data contains data for past 3 years and I only want to show data for curr month-1, curr month and curr month+1. It has to be dynamic . Can you kindly help me with that please.
Appricate your efforts.
Thanks & Regards
Shrey
Hi @sd22
You can create an Offset column which does this:
Offset =
var currentMonth= MONTH(TODAY())
return IF(MONTH(MyTable[Date])=currentMonth, 1 , IF(MONTH(MyTable[Date])=(currentMonth-1),1, IF(MONTH(MyTable[Date])=(currentMonth+1),1,0)))
And then put a filter in the pane for your graph <Offset=1>
Hi @sd22
If your data is as you have put, then you only need to use a matrix to visually see it as you need:
1) Put in rows: Item
2) Put in columns: Month
3) Put in values: Quantity
Btw, you can disable totals
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 |
---|---|
106 | |
104 | |
79 | |
68 | |
61 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
70 |