Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |