Hi Expert, I'm interested in comparing the resource count between any two given months say April and May for those departments that were existed in the previous month as well. For inst...
Hello everyone, I am trying to create a new measure in which I index monthly sales to the very first month (i.e., January 2023). My goal is to compare monthly sales to January 2023. ...
Hello everyone, I created a dummy spreadsheet and PBI files to help me explain the issue I am facing since I am working on confidential data. I am trying to create a clustered colum...
My situation: I need to count the rows of 'Open' tickets. Through YouTube and this Forum, I came up with a couple of measures that I thought would work for sure. However, I keep getting t...
Hey all, I run a spreadsheet extract through a cruncher for a contact centre that calculates times in [h]:mm:ss format Example would be if a team total had 6 people working 8 hours, the t...
Hi all, Please someone help on the below issue Issue: "Ending NAV is derived based on the maximum date from the running total (cumulative daily NAV since inception) . Here locking ending NAV at max...
I have below matrix where I am trying to apply row level conditional formatting but it is only working for whole of matrix. I can't believe PowerBI doesn't have this feature natively available. ...
DataSource.Error: AnalysisServices: The query referenced calculated table '<ccon>Fact_Ledger</ccon>' which does not hold any data because there is an error in its expression. Hello all...