version control
4 Topics
Is there a way to create measure to Sum of Product measure?
I have Table A Snapshot ID.1 ID.2 Avg Demand 2/12/2024 1 A 20 2/12/2024 2 A 30 1/12/2024 3 B 40 Table B Snapshot ID.1 LT 2/12/2024 1 2 2/12/2024 2 3 There is a data connection between table A & B on ID.1 2 Slicers to select the snapshot for Table A & Table B I have created a Measure to calculate LT* Avg Demand Now I want to create another measure which do WT LT* Avg Demand i.e., SUM(LT*Avg Demand) instead of SUM(LT)* SUM(Avg Demand) at ID.2 level. Sort of do first row wise calculation of LT* Avg Demand and then sum it at ID.2 level. As current measure is doing SUM(LT)*SUM(Avg Demad). Thanks KartikSolved355Views0likes1Comment
Ability to use Themes and VersionControl in Report Server
Hi two unrelated questions: 1. PowerBI Service links to OneDrive/Sharepoint where I can post new pbix in sharepoint and it automatically updates in the PowerBI Service. We use sharepoint to maintain version control so it's great that Sharepoint and PowerBI Service link together. Now the problem is that we moved to Report Server. I have been unable to find this capabilty in Report Server. Essentially, Sharepoint and Report server isn't linked. So everytime I have a new update, I must upload it to Report Server and then update sharepoint with the updated pbix (to maintain version control). I can't just do it once likeI did with the Service. Any workaround? Or perhaps the feature is available but I missed it. 2. Another feature I find missing is the use of Themes. With the regular desktop version (not optimized for Report Server), I was allowed to import color Themes. This is useful b/c I could load my companies colors to the desktop and all my visuals take on the colors themes I imported. The Desktop optimized for Report Server doesn't have this or I missed it. My work around is that I open the pbix in the regular Desktop version and import the Theme. Then open it back up on the optimized for Report Server version and publish from there. Can someone confirm the feature isn't available or does anyone have a better work around? Thanks.Solved3.7KViews1like3Comments
