I have three Tables as below in my My Model Parts, Baseyear and End Year. Parts have Columns as Customer group, Country, Supplier, Sales, Year. Base year and End Year are used in Page level filters and I needed use them on my measures for filtering ...
i have two tables created through SQL Server queries and imported into Power BI. The first one is Actual revenue and the second is Budget revenue. I have created a measure called FY20 Rev with the following formula ( FY20 Rev = CALCULATE(SUM('QRY_Actuals_New_rpt'[Producer ...
Over the past few weeks, we have all been tested with complex issues and have had to adapt both at work and at home. Through this time of uncertainty, your User Group community remains here for you to support one another. Think of some of the challenges ...
Hello All, I'm trying to implement a logic that will trigger a date(text) change in SSAS. I have created this manual custom column if [Month_Aq] > 202002 then if [#"Actual/Forecast"] = "Actual" then "Remove" else "Keep" else "Keep". so every month ...
It's a very odd problem i have a power bi workspace, that i publish a report to and a dashboard. Every page updates correctly, except this one card. When i refresh the card in my desktop version updates, the same for the scheduled update in the service, ...
Hi folks! In the last few days we have observed several news about the Coronavirus that started in China and around the world today is globalized in several regions of the world! My concern is to understand the seriousness of this moment and nothing ...