ExcelQuestion
New member
- Joined
- May 27, 2018
- Messages
- 26
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office 365
Dear Experts,
Using Power Query, I was able to group item based on:
1) [Date] <= "Cutoff Date" parameter input, AND;
2) [Match ID] <> total $0
Trouble is...the user experience isn't intuitive for the common office environment. The user has to enter the "Cutoff Date", then Refresh.
Huge risk...when the user doesn't Refresh but just prints the un-freshed report.
Also, my actual Source Table is a larger dataset utilizing relationships...prefer not to Merge existing data into the Power Query just for this one report.
Lastly, all my existing reports are DAX pivot tables...trying keep the same look and feel for the audience.
How do you create the Power Query method using DAX pivot table? Definitely need to show the Cutoff Date as part of the pivot table.
Thanks in advance,
Ricky
Using Power Query, I was able to group item based on:
1) [Date] <= "Cutoff Date" parameter input, AND;
2) [Match ID] <> total $0
Trouble is...the user experience isn't intuitive for the common office environment. The user has to enter the "Cutoff Date", then Refresh.
Huge risk...when the user doesn't Refresh but just prints the un-freshed report.
Also, my actual Source Table is a larger dataset utilizing relationships...prefer not to Merge existing data into the Power Query just for this one report.
Lastly, all my existing reports are DAX pivot tables...trying keep the same look and feel for the audience.
How do you create the Power Query method using DAX pivot table? Definitely need to show the Cutoff Date as part of the pivot table.
Thanks in advance,
Ricky