How to get distinct cumulative Sum of Day wise
Hi Community Member, Please help me to achieve some desired result using power bi dax. Please see the attached details explanation and output we need. See below calculation that we need to convert into power bi dax to achieve output mentioned right side below.
okay icon
I have the following table. And I have the following matrix look The "Planned" measure is: CALCULATE( SUM( fac_NFs_SFs[valor_liquido_nf] ), USERELATIONSHIP( dim_Calendario[Data], fac_NFs_SFs[data_previsao_recebimento] ) ) The "Achieved" measure is: CALCULATE( SUM( fac_NFs_SFs[valor_liquido_nf] ), USERELATIONSHIP( dim_Calendario[Data], fac_NFs_SFs[data_recebimento] ) ) The months "Mar", "Mai" and "Jun" = dim_calendario[mês] I need that when I have a receipt date, all the month contexts have the Okay icon, ignoring the month of the column context. I can't do this because the forecast sum uses the forecast column and the received sum uses the received date column. What do I do?
Calcualted column from two distinct tables
Hello , I am creating a calcualted column which is basically dividing one value by another. Both the columns are present in two different tables and they are connected via bridge tabes as nothing is common between them. So below is a picture of my data model. The calculation isnt coming up correctly. What may be the possible reasons for it ? Calcualtion - The One column is from cross channel table and other column is from benchmark table. Both are basically just getting divided.Exclude user with condition from the chart
Hi everyone, I have a problem that I hope you can help me with. I have user data tracked by events. I want the chart to filter out users who have at least one event_type=1 within a specified time period. However, when I add this measure to a chart with the Y-axis as Month and Year, it doesn't work. Here is the measure I wrote: actions_by_user_not_having_event1 = var cte = filter (SUMMARIZE( fact_event, fact_event[user_id], "MinEventType", CALCULATE(MIN(fact_event[event_type]), ALLSELECTED('Date'[Date])) , "events", COUNTROWS(fact_event) ), [MinEventType] > 1) return SUMX(cte, [events]) Thank you guysNext Year Budget/Forecast in Current FYear
Hi There, I am stuck and running out of ideas for a use case I recently received. Writing down the Use case below: We have a Forecast table that locks the forecast based on the fiscal year i.e for FY2023 and FY2024 they upload the forecast scenarios in the following manner: F23Budget F23E1 F23E2 F23E3 F24Budget So the catch here is that for every forecast entry they will have the mentioned Fiscal year forecast and also the forecast they imagined that they would have for next fiscal year. For better understanding look at the below table. Scenario TimeID F23E1 01-07-2022 F23E1 01-08-2022 F23E1 01-09-2022 F23E1 01-10-2022 F23E1 01-11-2022 F23E1 01-12-2022 F23E1 01-01-2023 F23E1 01-02-2023 F23E1 01-03-2023 F23E1 01-04-2023 F23E1 01-05-2023 F23E1 01-06-2023 F23E1 01-07-2023 F23E1 01-08-2023 F23E1 01-09-2023 F23E1 01-10-2023 F23E1 01-11-2023 F23E1 01-12-2023 F23E1 01-01-2024 F23E1 01-02-2024 F23E1 01-03-2024 F23E1 01-04-2024 F23E1 01-05-2024 F23E1 01-06-2024 in Order to seperate the original F23E1 and the Temp F23E1 we seperated the scenario into 2 diff scenarios again as below: Scenario TimeID Scenario ID F23E1 01-07-2022 Budget E1 F23E1 01-08-2022 Budget E1 F23E1 01-09-2022 Budget E1 F23E1 01-10-2022 Budget E1 F23E1 01-11-2022 Budget E1 F23E1 01-12-2022 Budget E1 F23E1 01-01-2023 Budget E1 F23E1 01-02-2023 Budget E1 F23E1 01-03-2023 Budget E1 F23E1 01-04-2023 Budget E1 F23E1 01-05-2023 Budget E1 F23E1 01-06-2023 Budget E1 F23E1 01-07-2023 Next Fiscal Budget E1 F23E1 01-08-2023 Next Fiscal Budget E1 F23E1 01-09-2023 Next Fiscal Budget E1 F23E1 01-10-2023 Next Fiscal Budget E1 F23E1 01-11-2023 Next Fiscal Budget E1 F23E1 01-12-2023 Next Fiscal Budget E1 F23E1 01-01-2024 Next Fiscal Budget E1 F23E1 01-02-2024 Next Fiscal Budget E1 F23E1 01-03-2024 Next Fiscal Budget E1 F23E1 01-04-2024 Next Fiscal Budget E1 F23E1 01-05-2024 Next Fiscal Budget E1 F23E1 01-06-2024 Next Fiscal Budget E1 Now when we calculate the values based on the scenarios as the above fact table has a relationship with Calendar table, When the calculated scenarios are placed in the matrix and the fiscal year is used in the atrix they both are seperated into 2 different Fiscal years as below: But the catch here is that, The user doesn't want to see the 2 scenarios falling into different fiscal years, as the next fiscal E1 FY is actually coming from F23E1 they would like to see both in the same fiscal year as below: But the calculations or the dax that I'm using here are not the right one's or not meeting my expectations. for the above visual to work I have used Dateadd and ignored the Scenario ID and calculated it for Next Year but whenever I switch between fiscal years it is showing me the data for FY2022 as well. Does anyone know any other way this could work. Any suggestions or any links that can help me find a solution works. Thanks in Advance. amitchandak lbendlin Greg_Deckler technolog parry2k Ritaf1983 Idrissshatila Ahmedx
Power BI Stacked chart - Time vs Category visual
Hi @ConnieMaldonado @BA_Pete @kewaynes @v-alq-msft , I have a quick query in regard to how to use a stacked bar chart in Power BI which would show the category vs. Time. I was able to create one in Excel using time series But trying to figure out the same in Power BI Visual. It would be really helpful if someone could share their thoughts on the same. Please feel free to reach out to me on any additional information. Excel Graph: I colored the cells of Layover to White (So it shows as a gap), Blue highlighted are all Travel times. Raw data Sample: ID Number Start Time Travel Layover Travel Layover Travel Layover Travel Layover Travel Layover Travel 3 05:25:00 00:23:00 00:07:00 00:31:00 00:14:00 00:30:00 00:15:00 00:42:00 00:18:00 00:40:00 00:20:00 00:36:00 4 05:25:00 00:23:00 00:07:00 00:25:00 00:05:00 00:32:00 00:13:00 00:40:00 00:20:00 00:45:00 00:15:00 00:37:00 I really appreciate the help! Looking forward to the tips/solution. Regards Vishnuhow to calculate lost customer distinct count on month level using dax measure in power pivot?
Hello everyone, I hope you're all doing well. I'm currently working on a project and could use some guidance regarding a DAX measure. I'm trying to calculate distinct counts for different types of customers on a monthly basis, and I'm encountering a few challenges. Specifically, I'm aiming to determine the following metrics using DAX measures: Lost Customer Distinct Count: The count of customers who were active in the previous month but haven't made any transactions in the current month. New Customer Distinct Count: The count of customers who are making their first transaction in the current month. Repeat Customer Distinct Count: The count of customers who have made transactions in both the current month and the previous month. The database has been loaded into Power Query, and I've successfully established connections in Power Pivot. Additionally, I'm hoping to enhance this analysis by segmenting the results based on categories and brands, if possible. If any of you have experience with DAX measures and are willing to lend a helping hand, I would greatly appreciate it. Your expertise could make a significant difference in advancing this project. Thank you in advance for your support. Looking forward to your insights! Best regards, Santosh Sample database table for reference. date customer id 01 January 2022 cust-001 02 January 2022 cust-002 03 January 2022 cust-003 01 January 2022 cust-001 01 February 2022 cust-001 02 February 2022 cust-002 03 February 2022 cust-004 02 February 2022 cust-002 01 March 2022 cust-001 01 March 2022 cust-002 01 March 2022 cust-005 01 March 2022 cust-002
