fixed Average of a value when multiple dates are selected from slicer.
Hi, I am calculating KPI for Actuals vs Target, the target and actuals are Average values and I get single value however as soon as i add KPI into the visual i get three different KPI whereas the KPI were to be calculated based on the average of actuals and target. I am trying to get KPI when multiple dates are selected from slicer. I also have different targets for different months. for example, in the table below I wanted to get a single KPI for average of target and average of Actual. I am using a date filter and Room Name filter in this table visual. the KPI for this visual was supposed to be bad as the average of actual is over the Average of target value. How can i make sureto get a single KPI in this condition, i am using this kpi to format my Gauge Axis Visual. how to get a single value for Average of Target and Actual when i select multiple or a single date from the slicer. Thank you !
Two Fact Tables Nightmare - Calling all Power BI Gurus
I'll be refreshing this page every minute in hopes that a Power BI Guru can save my project. I was given a Historical-Current Fact Table, we will call this TABLE 1, where they wanted a plethera of measures that analyzed trend in multiple areas. Example would be like Total Sales - Easy to do. I was then asked to make a Forecast Table out of Dax, we will call this TABLE 2. This table had only had one column - Years. Under this column, were 3 rows "2023, 2024,2025". Easy. With this Forecast Table, they asked for me to make measures that forecasted what the future trend would be based applying on what paramters on the Current Year. This was doable. I was able to apply CAGR based on the Current data provided in TABLE 1. Each table has it's own measures for things like, total sales, total product, ect. Now, I'm being asked to Create a 3rd Table, a Date Table, for the specific use of displaying Table 1 and Table 2 data together. Pictures below. Now, I tried Using UNION to combine the 2 Fact tables, not working. Can someone please help me? PLEASE NOTE.. TABLE 1 "HIST SALES" IS A MEASURE, AND TABLE 2 PROJECTED SALES IS A MEASURE...I'M HOPING THAT IT'S POSSIBLE TO ACHIEVE TABLE 3 TO SHOW RUNNING TOTALSCAGR HELP! Forecasting using Current data
I literally forgot how to do this, please help. I have a table that has 2018-2022 Year sales. I created a whatifparameter from 0-100% to be the CAGR value. Focusing only on 2022 sales, I want the user to be able to select their desired CAGR % and see what the how it impacts 2023-2025 forecasted sales. Forecasted Sales is dax table using Union Row...example below
Search final category from hierarchy table for each organization (even duplicates for each keyword)
Hi All, Could you please help me with DAX function or Powerquery to solve the below requirement? i need to have one final category for each keyword and organization group. if org & keyword is unique then need to retain the already found category in the final category column
