kpi card
2 Topics
Issue with DAX Calculation
Hi guys! First of all thanks for reading and helping. Ok, let's suppose i have some price data like this Owner SKU BRAND DATE PRICE DESC RETAIL Company 74258323 A ######## 1180 Prod A WALMART Competitor 14325325 B ######## 3273 Prod B WALMART Competitor 1212434 C ######## 644 Prod C WALMART Competitor 12145346 D ######## 683 Prod D WALMART Company 74258323 A ######## 2154 Prod A WALLGREENS Competitor 14325325 B ######## 1945 Prod B WALLGREENS Competitor 1212434 C ######## 733 Prod C WALLGREENS Competitor 12145346 D ######## 577 Prod D WALLGREENS Company 74258323 A ######## 1742 Prod A TARGET Competitor 14325325 B ######## 1112 Prod B TARGET Competitor 1212434 C ######## 589 Prod C TARGET Competitor 12145346 D ######## 712 Prod D TARGET What i'm trying to calculate via DAX is a Price Index with this custom formula: (AVG Selling Price of my products / AVG Selling Price of my competence) * 100. I have so far this two meassures: ASP_Compete = CALCULATE( [ASP], 'Table'[Owner] = "Competitor" ) ASP_Company = CALCULATE( [ASP], 'Table'[Owner] = "Company" ) And a separate one for the price index wich is: Price Index= DIVIDE(ASP_Comp, ASP_Compete) * 100 From my logic it should work fine, but when i drop into any vissual i got the error: "Error fetching data for this visual: An unexpected exception occurred" Do you know if this is related to an issue of Power BI's version? Thank u again for your answers. RegardsSolved467Views0likes1Comment
How to view previous month as text in a KPI card
Hi, I would like to create a KPI card which shows the previous month as a text. For example, if it is January 2023 today then the previous month should display as 'December 2022' in the KPI card. I tried to use the PREVIOUSMONTH function but the KPI card shows blank. I would appreciate any tips or suggestions. Many Thanks Best Regards RoshanSolved892Views0likes2Comments