Current day Ending balance should show up as Starting balance for next day
Hello Folks, Need your help to figure out this interesting qusetion. How to write a DAX expression/measure to show currrent day ending balance as a Starting balance for next day and continue addin up as shown in the example below: Any ideas? Thanks in advance.
Refresh failure -It looks like the refresh token expired. Please go to this dataset's settings page,
Hi, I am facing this issue from few days and the scheduled refresh does not work. Below is the error description: It looks like the refresh token expired. Please go to this dataset's settings page, and reenter the undefined credentials for the undefined data source. Cluster URI: WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net Activity ID: d796f6fa-b4ba-4059-9dc8-bb3ed5e19ede Request ID: 54aab39a-94b7-4c63-bcc5-af0ae7a43821 Time: 2020-03-04 14:14:01Z If i try to manuly refresh it works for me. But what can be done to get rid of this issue. My data is coming from a cube, it is a direct query. Thanks.
Overlay during visual refresh
So when dealing with multiple visualisations across data you get the lovely loading circle in the upper left corner. I'm wondering if anyone knows how this functions and if it can be modified to take up the entire visualisation frame or if anyone has customised it themselves?
Previous QTD as of today for each quarter
Help me to create a Dax measure to show the Previous QTD actuals as of day(today) for each quarter. I have date , amount columns for example today is 6/19/2024 so we would like to see 2024-Q1 data from start of quarter to till 3/19/2024 2023-Q4 data from start of quarter to till 12/19/2023 2023-Q3 data from start of quarter to till 9/19/2023 2023-Q2 data from start of quarter to till till 6/19/2023 Currently, I am using this measure. But this is giving Total QTD.Previous Quarter QTD Actuals should be less than QTD Rev Previous Quarter QTD Actuals = calculate(SUM(Amount]),DATEADD(filter(DATESQTD('Calendar'[DateVal]),Calendar'[DateVal]<TODAY()),-1,QUARTER))
Concatenate 3 column values as icons
I am tracking Sales to Pace (target) and need to display a matrix column with past 3 month's results as 3 concatenated icons. Example with : Here's my base DAX I've trying different methods with: $ to Pace Cumulative = 'DAX Measures'[Created] - 'DAX Measures'[Combined Pace Cumulative Table] $ to Pace LCM = CALCULATE([$ to Pace Cumulative], 'Date Table'[CurrMonthOffset] = -1) $ to Pace LCM-2 = CALCULATE([$ to Pace Cumulative], 'Date Table'[CurrMonthOffset] = -2) $ to Pace LCM-3 = CALCULATE([$ to Pace Cumulative], 'Date Table'[CurrMonthOffset] = -3) $ to Pace LCM Icon = SWITCH(TRUE(), 'DAX Measures'[$ to Pace LCM] > 0, UNICHAR(9650), 'DAX Measures'[$ to Pace LCM] < 0, UNICHAR(9660), BLANK()) $ to Pace LCM-2 Icon = IF('DAX Measures'[$ to Pace LCM-2] > 0, "✅", "❌") $ to Pace LCM-3 Icon = IF('DAX Measures'[$ to Pace LCM-3] > 0, "🟢", "⭕") Combined Icons = [$ to Pace LCM-3 Icon] & " " & [$ to Pace LCM-2 Icon] & " " & [$ to Pace LCM Icon] The [Combined Icons] column is [Last 3 Months] in example matrix. Since I'm trying to represent the value of [$ to Pace Cumulative] as an icon only, I haven't been able to come up with a measure for conditional formatting that correctly designates a color for the unicode triangles or an icon for the values of concatenated measures. Ideally, I want to display these native PBI icons for above 0 and below 0: However, the following DAX doesn't work: $ to Pace LCM-2 Icon = IF('DAX Measures'[$ to Pace LCM-2] > 0, "TriangleHigh", "TriangleLow") I also couldn't get image URLs to work in this measure. Any idea how I can display the [Last 3 Months] column using the above native Power BI green and red triangles?Previous 2 year values for current top 7 countries and others
I want to show the sales of TOP 7 countries for the selected year and the remaining sales I need to add up the country and show it as "Other" in Country Name column. After that, Based on current top 7 countries names i need to compare with previous last two years same country sales amount. Calendar Country Name Total 2024 Qatar 18.98 2024 Australia 15.28 2024 Malaysia 12.2 2024 UK 9.64 2024 United States 4.56 2024 Netherlands 3.32 2024 Canada 1.28 2024 Others 17.4 Expected Ouput: Comparing current top 7 countries with previous year Calendar Country Name Total 2024 Qatar 18.98 2024 Australia 15.28 2024 Malaysia 12.2 2024 UK 9.64 2024 United States 4.56 2024 Netherlands 3.32 2024 Canada 1.28 2024 Others 17.4 2023 Qatar 20.98 2023 Australia 17.28 2023 Malaysia 16.2 2023 UK 10.64 2023 United States 9.56 2023 Netherlands 8.32 2023 Canada 6.28 2023 Others 19.4 2022 Qatar 22.98 2022 Australia 17.98 2022 Malaysia 13.2 2022 UK 11.64 2022 United States 10.56 2022 Netherlands 9.32 2022 Canada 7.28 2022 Others 19.76 Measure used: Total Sales = VAR _start= Year(MAX ( 'Calendar'[Date] )) VAR _end = _start - 2 CALCULATE ( ROUND( CALCULATE(Sales amount),2), ALL ( 'Calendar' ), FILTER ( 'DATE', year('DATE'[DATE_TIMESTAMP_DTM]) <= _start && year('DATE'[DATE_TIMESTAMP_DTM]) >= _end ) ) This measure i used to calculate top 7 and others, and also to display last 2 year sales value comparsion with current year sales values of the top 7 countries Top7= VAR Top_N = 7 VAR TOPNCOUNTRY = TOPN(Top_N, ALL('COUNTRY'), [Total Sales] ) VAR ALLCOUNTRY = CALCULATE( [Total Sales],ALLSELECTED('COUNTRY')) VAR OTHERCOUNTRY = ALLCOUNTRY - CALCULATE( [Total Sales,TOPNCOUNTRY) VAR TOPNCOUNTRYDIS = CALCULATE( [Total Sales],KEEPFILTERS(TOPNCOUNTRY)) VAR CURRENTPCOUNTRY = SELECTEDVALUE('INTENSITY COUNTRY'[COUNTRY]) RETURN IF( CURRENTPCOUNTRY = "Others", OTHERCOUNTRY, TOPNCOUNTRYDIS ) Problem: Previous year values for current top 7 countries name is not happening instead each year it displays top 7 and othersConverting Tableau Calculation into Power BI
Hi, I am in the process of converting a load of Tableau dashboards into Power BI but cannot figure out how to translate this particular measure and was hoping someone could point me in the right direction: Measure from Tableau: COUNTD([SNO]) / TOTAL(COUNTD([SNO])) I know COUNTD( ) in tableau is DISTINCTCOUNT( ) in Power BI. But not able to figure out the total part and also used this calculation SUMX( ALL(Query1), DISTINCTCOUNT([SNO]) ) by taking reference from the forum. But, it's not working as expected. Any help would be appreciated Many Thanks in advance
