olzgoal.blogg.se

So, I decided to write a blog post on how you can do it – Using Calculation Groups in #PowerBI to implement a Many 2 Many (M2M) filter I have had a couple of people posting comment on one of previous blogposts “Setup data driven report subscriptions for #PowerBI paginated reports with #PowerAutomate” asking me on how to specify values for multi value parameters in a Paginated reports. As I want it as a table I use the Ribbon interface to convert the list of dates into a table Which then gives Multivalue parameters in #PowerBI paginated report when using #PowerAutomate to export to file When I build date tables I typically use the function List.Dates to create a list of dates. Here is a tip that reduces your Power Query steps with 1 step less. When you build a date table in Power Query you might use the functions under Date to add year, month and day And this will give you three steps in your Query But we can do this a bit faster, and you will save a few clicks with your mouse If you add a custom How to avoid a rename step in #PowerQuery when you use Table.FromList – #PowerBI

#PowerQuery – Add Year, Month and Day to your date table with Date.ToRecord – #PowerBI