Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi everyone!
I am trying to show 7 days before sales quantity on column.
For represent task clearly, let me show result table as a screen of excel, which I am looking for, but in aiming of simplicity, not for 7 days before, but 1.
Sorry of using not a power bi data scree. That's cause of big data volumes in power bi area
Tryed to use LOOKUPVALUE and DATEADD, but without success
Solved! Go to Solution.
Hey,
an easy way is to create a seperate table like:
let
Source = YourTable
in
Table.Group(YourTable, "GroupByColumn", {"Total", each List.Sum([SumColumn])})
in
Source
Have a look to following function
https://msdn.microsoft.com/en-us/library/mt260774.aspx
You should be able to add your Date column as a slicer on your report page and if you click the little drop down arrow on the right-hand side of the visual you can select Relative and enter a number of days.
It Is helpfull addition, but i need to see comparisons, as in result table in screen above
Hey,
an easy way is to create a seperate table like:
let
Source = YourTable
in
Table.Group(YourTable, "GroupByColumn", {"Total", each List.Sum([SumColumn])})
in
Source
Have a look to following function
https://msdn.microsoft.com/en-us/library/mt260774.aspx
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |