Calculate variance dynamically between two dates even part is replaced
Hi Team, we have a requirment to calculate variance between two dates (slicer to select date1 and date2). Bridge list contains Old index and New index -- which means old index is a Index on Date1 and New Index is replaced Name. even though they looks different but they are same. we should do variance between INDIA|PUNJAB|A9867|3 INDIA|PUNJAB|A9898|3 Bridge List Old Index New Index INDIA|PUNJAB|A9867|3 INDIA|PUNJAB|A9898|3 SOURCE COUNTRY STATE Name ID Colour Value DATE INDEX INDIA DELHI Y1864 1 GREEN 60 27-Jan-23 INDIA|DELHI|Y1864|1 INDIA GOA Z2345 2 BLUE 70 27-Jan-23 INDIA|GOA|Z2345|2 INDIA PUNJAB A9867 3 GREEN -190 27-Jan-23 INDIA|PUNJAB|A9867|3 INDIA DELHI Y1864 1 GREEN 80 31-Jan-23 INDIA|DELHI|Y1864|1 INDIA GOA Z2345 2 BLUE 70 31-Jan-23 INDIA|GOA|Z2345|2 INDIA PUNJAB A9867 3 GREEN -150 31-Jan-23 INDIA|PUNJAB|A9867|3 INDIA PUNJAB C1234 4 GREEN -100 31-Jan-23 INDIA|PUNJAB|C1234|4 INDIA DELHI Y1864 1 GREEN 60 2-Feb-23 INDIA|DELHI|Y1864|1 INDIA GOA Z2345 2 BLUE 70 2-Feb-23 INDIA|GOA|Z2345|2 INDIA PUNJAB A9898 3 GREEN -200 2-Feb-23 INDIA|PUNJAB|A9898|3 INDIA PUNJAB C1234 4 GREEN -100 2-Feb-23 INDIA|PUNJAB|C1234|4 OUTPUT1 Select slicer1 & slcier 2 (Date1 27-Jan-2023 & Date2 31-Jan-2023) INDEX ON DATE1 INDEX ON DATE2 COLOUR ON DATE1 COLOUR ON DATE2 VALUE ON DATE1 VALUE ON DATE2 DELTA INDIA|DELHI|Y1864|1 INDIA|DELHI|Y1864|1 GREEN GREEN 60 80 20 INDIA|GOA|Z2345|2 INDIA|GOA|Z2345|2 BLUE BLUE 70 70 0 INDIA|PUNJAB|A9867|3 INDIA|PUNJAB|A9867|3 GREEN GREEN -190 -150 40 INDIA|PUNJAB|C1234|4 GREEN -100 -100 OUTPUT2 Select slicer1 & slcier 2 (Date1 = 31-Jan-2023 & Date2 2-Feb-2023) On 2-Feb-23 INDIA|PUNJAB|A9867|3 is replaced as INDIA|PUNJAB|A9898|3 so PBI should identify the replacement by referign brdigelist tablew INDEX ON DATE1 INDEX ON DATE2 COLOUR ON DATE1 COLOUR ON DATE2 VALUE ON DATE1 VALUE ON DATE2 DELTA INDIA|DELHI|Y1864|1 INDIA|DELHI|Y1864|1 GREEN GREEN 60 60 0 INDIA|GOA|Z2345|2 INDIA|GOA|Z2345|2 BLUE BLUE 70 70 0 INDIA|PUNJAB|A9867|3 INDIA|PUNJAB|A9898|3 GREEN GREEN -190 -200 -10 INDIA|PUNJAB|C1234|4 GREEN -100 -100 Regards, Reddy.How to publish Power BI report to Power BI Report Server
Hi Everyone, What I wanted to know is how can I publish report on Power BI Report Server as shown below: But since I am using Power BI Desktop version - 2.121.762.0 64-bit (September 2023) I am unable to save nor share report to Power BI report Server. Furthermore, I tried to use Power BI Desktop version 2.117.984.0 64-bit (May 2023) but since it does not support some of the preview features such as shape map etc that are required for my project I am not able to solve this by switching to that version. Are there any workarounds that I could implement using Power BI Desktop version - 2.121.762.0 64-bit (September 2023) ? or do I have to use different Power BI Desktop version with different workaround? If anyone can help me with this it would be much appreciated.
Pro licence vs free version issue
Hello team Really bizarre issue. In our organization, we are 3 data people with pro licence. The rest of the team uses the free version and they get the links to reports as needed. One team member created a pro licence trial account, since then he cannot see any report. We have tried to closed his account and open it back again but that doesn't seem to work. Ideally we would like him to go back to free licence and open the links as the rest of the team. Any suggestions on how to fix these? Many thanks!!! 😊Need Help!! Jira lifecycle
Hey Champs, I am getting data from Jira to PBI report server. I want to calculate the time when a ticket leaves a status. I have the following columns: Issue ID Timestamp (when the issue moves from 1 status to another) Status to (status it moved) Status from (Status from where it moved) I cannot find the DAX formule or power bi . just need a column.
Urgent Help - Average number of days
Hey champs, I need some advice how to solve this situation. I want to show average number of days a ticket stayed in a particular status. Values of this matrix i average of days / status jan feb mar APRIL MAY JUNE JULY AUG SEP STATUS1 STATUS2 STATUS 3 Problem statement: What if there are 10 issues and 9 issues took 30 days where as 1 issue took just 2 days. so average of this will be 3 days. What way i can show the variance too? i am using PBI desktop RScurrent 12 dates
how do i display current 12 dates with a date selected as parameter? I have a report with a date field, where i should display only the current 12 dates where the maximum date is the selected date from the date parameter. Is there any way i can bring it up in the powerbi report builder?
Need Help Finding BigFix Service Accounts Report
Hello, There was a Report that I Exported into Excel from BigFix called ExploreComputers and contained the fields -Domain -Computer Name -Service Account Names -Active Directory Path - IP Address -OS -CPU -Last Report Time This was 6 months ago and I can't seem to find a Report in BigFix that contains that Information. The Excel Info Tab shows it was Authored by Russ Eidemiller, but I do not find him listed in E-mail or Teams. If the exact Report cannot be located, I can make do with a new Report that contains either Server Name or FQDN and the Service Account Names. As I am fairly new, creating Custom Reports is not my specialty. I would appreciate any help to complete this Report. Thanks, James Worden
