IF value exists on calendar date
Hi everyone, i need help creating a measure that evaluates whether a value in on table exists at a particular date within the calender table . I am working with Two tables, on main table that has a customer and a purchase date. The second table is just a table showing the daily calendar dates. the outcome wanted is to evaluate whether a purchase was made by a customer at a certain date on the daily calender. the tables are as shown below : RESULT If a customer has purchased something on the date equivalent to the calendar date, return true, else false. as shown below: If anyone could assist me with writing a measure that could produce this outcome that would be wonderful 🙂 all help and sugegestions are welcome: Thank you
create area chart with green and red colors to indicate profit and loss
I have created area chart that that shows profit and loss % over time. I would like to show the loss (negative part) in red color and the profit ( positive part) in geen color. i created 2 measures one for profit % and one for loss % positive p&l = var pl=[p&l %] var result= IF(pl>0 , pl,0) return result negative p&l = var pl=[p&l %] var result= IF(pl<0 , pl,0) return result when i added the measures in the chart it looked like: any idea on how to create the area chart with green/red colors instead of 1 color
Month Abbreviation
Hi, in my data I have two fields YEAR and MONTH that I used to create a new column Date = DATE (Data[YEAR],Data[MONTH] ,1) and setting its data type as Date/time I obtain this: which I used to build different graphs., e.g. The problem is that I would use the abbreviated month to save space but I cannot find the way, I tried several approached but none of them worked. Could you help me?Measure: show dcount as % by date hierarchy
Hey everyone, i've just started in power bi and im having trouble with some calculations, for starters i just nee to calculate and graph the On Time KPI foe my company deliveries. I have scheduled delivery date and time with low and high limits as first set of data, an then i have the real delivery date and time, everything identified by a unique delivery ID. I basically need to calculate compliance % in 3 levels (Early, on time, and late) and graph them by date hierarchy. My data structure is as follows: Guide Min Time of Arrival Max Time of Arrival Arrival Time On Time On Time (groups) 12345 11/11/2020 06:00 11/11/2020 07:00 11/11/2020 05:00 Early On Time 23456 11/11/2020 06:00 11/11/2020 07:00 11/11/2020 06:30 On Time On Time 34567 11/11/2020 06:00 11/11/2020 07:00 11/11/2020 14:00 Late Late On Time - Column is the result of the following calculation: (which i added in Power Query using M while transfoirming my data) = Table.AddColumn(#"Extract - Hora Creación", "On Time", each if [Tiempo Llegada] < [Tiempo Min Entrega] then "Anticipado" else if [Tiempo Llegada] > [Tiempo Max Entrega] then "Retraso" else "On Time") On Time (groups) - just groups early and on time for practical purposes my company considers both as acceptable, so if the sum of both is greater than 70% everything is ok. I tried the following dax formula for the measure im trying to graph and it does. On Time KPI = CALCULATE(COUNT(Beetrack[On Time]),ALLEXCEPT(Beetrack,Beetrack[Tiempo min entrega].[DÃa],Beetrack[On Time])) / CALCULATE(COUNT(Beetrack[On Time]),ALLEXCEPT(Beetrack,Beetrack[Tiempo min entrega].[DÃa]))​ The problem here is the resulting graphs cant be affected by any filter, and cant be drilled down/up by any date hierarchies, so i cant show monthly nor annual nor weekly values. I also cant highligt the same data when i click on other graphs in the dashboard to segment the data. Is there any other way to achieve the same calculation dynamically? so i can get the values by date hierarchies? and that the graph is not always static?Chart order by last 12 Month: Start to end
Hello, I'm showing the last 12 months( last month is May 2020 ) data but I'm unable to show order like from start to end (June to May) See the graph : (There is no data for some months so it's ok if some months are not in the graph) So actual graph order: September, November, May, July, January, December, April What I want: July, September, November, December, January, April, May What I already did till for order : 1.Try to change the sort by rank column but got this error : 2.Also, I can show perfect order if I add the year from Date Hierarchy but its add year in the axis which I don't want like this: May 2020 I attach a file please take a look: testFile.pbix Thanks In advanceHelp Needed - DAX Measure for Financial Summary Visualization
Hi PBI Community I'm new to PBI, not very comfortable with advanced DAX measures, hence asking for help. Example show as below, I want to display the list of values in my new summary report. Data coming from two tables actual (data source - SQL) and budget (excel). I've created a dummy screenshot for better understanding. Please don't follow the values, it is just for explanation purposes. 1. Picture - My final vizualisation metrics 2. Picture of database 3. This is what I've achieved so far. I've unpivoted the budget data and made some model changes, nothing producing me the final outcome closer to Picture 1. I've created some measures but it is not showing me by week value rather it is summing up, something like this. Again not in an exact format what I'm looking for. The column highlighted in Red is not showing me with the correct figure, maybe my DAX formula needs some tweak. My aim is to attain the yellow figure which gives me the correct value by week Week to Date Sales DAX Measure = [ var CurrentDate=LASTDATE(DATES[Date]) var DayNumberOfWeek=WEEKDAY(LASTDATE(DATES[DATE]),3) return CALCULATE( SUM(Budget_Volume[Quantity]), DATESBETWEEN( DATES[Date], DATEADD( CurrentDate, -1*DayNumberOfWeek, DAY), CurrentDate)) Ultimately, my objective is to create a summary report with actual, budget and previous year figures to be filtered by week number displayed next to a week or by the filter. Also Cumulative and Cumulative Variances in different columns a shown in picture 1. I appreciate your help in assisting me with the custom visualization Regards
