Dynamically Pick Min Date based on slicer's selection
Hi friends, I am still new to Power BI, hope you guys can provide me some guidance. Here is my situation: I would like to pick min date for each level of percentile (low, mid, and high) from each provider separately based on the condition that the percentage in PctAvailable column is greater than the corresponding percentage in slicer (on the leftside of the screenshot below). I created three columns, LowDate, MidDate, and HightDate to store the calculated min dates. Also, I added columns LowPCT, MidPCT, and HighPCT to show the selected percents from slicers for demenstration purposes. Using provider 403 as example, the LowDate is 10/13, MidDate is 12/20, and HighDate is also 12/20 based on the current selections. However, the min dates of each level don't change when different values are selected. It looks like the min dates are selected using the min percentage of each level, not dynamically update based on the selection. I created three tables containing the values of each slicer, called LowSelection, MidSelection, and HighSelection. Here are the formulas that I used for the calculation (using Low percentile calcs as example) LowPCT= if(HASONEFILTER(LowSelection[Low]),LOOKUPVALUE(LowSelection[Low],LowSelection[Low],values(LowSelection[Low]))) LowDate= CALCULATE(min('Table'[SlotDatetimeDTS]),FILTER('Table','Table'[ProviderID]=EARLIER('Table'[ProviderID])&&'Table'[PctAvailable]>[LowPCT])) Please let me know which parts do I have fix or adjust? Thank you so much for your time!
Dynamic column headings - based on todays date
Hi, I'm really hoping this is possible. In an SSRS report we were able to code the column headings so they are dynamic based on todays date. I'm wanting to do the same in a table (it can be a matrix if needed). I've currently just renamed the columns but obviously this isn't going to work when the report is published. This is how we did it in SSRS: = "D " + vbcrlf + format(today(),"ddd") + vbcrlf + format(today(),"dd/MM") and then: = "D+1 " + vbcrlf + format(dateadd("d",1,today()),"ddd") + vbcrlf + format(dateadd("d",1,today()),"dd/MM") etc Thanks in advance
Looking for help - To show historical data conditionally
Hello everyone, I am new to Power BI and Dax, have an issue which looked simple initially but unable to crack it. I have opportunities datasets as below and a sample report as below. You can see in Rainmaker_Type2 dataset, some of the opportunities has changed its assigned rainmakers over time. My requirement is, when my below dashboard loads initially with a whole year view, opportunities should show the latest rainmakers Whereas if user clicks on "May" month in visual2 , the first visual should show the may month opportunities with rainmakers assigned at that point of time. Eg: On initial load, John to be shown against opportunity 172 where as if user clicks on May or Q1 (April/May/Jun) Sam should be shown against 172. As this rainmaker selection is dynamic depends on timeperiod selection, I am struggling, have tried with calculated measures/columns, but did not worked. Can anyone please guide me to remove this issue? Opportunities Dataset Opportunity_Key Opportunity_Created_Date Fiscal_Year Fiscal_Quarter Fiscal_Month Rain_maker TCV 96 4/10/2019 0:00 FY 19-20 Q1 Apr Donald 750000 100 4/26/2019 0:00 FY 19-20 Q1 Apr Donald 250000 172 5/16/2019 0:00 FY 19-20 Q1 May John 500000 183 5/16/2019 0:00 FY 19-20 Q1 May John 250000 186 5/16/2019 0:00 FY 19-20 Q1 May John 2200000 546 5/14/2020 0:00 FY 20-21 Q1 May Steve 2400000 Rainmaker_Type2 dataset Opportunity_Key Rain_Maker_GID Rain_Maker Effective_Start_Date Effective_End_Date 96 212048 Donald 4/10/2019 0:00 12/31/2050 0:00 100 212048 Donald 4/26/2019 0:00 12/31/2050 0:00 172 372077 Sam 5/16/2019 0:00 7/8/2020 0:00 172 239839 John 7/8/2020 0:00 12/31/2050 0:00 183 372077 Sam 5/16/2019 0:00 7/8/2020 0:00 183 239839 John 7/8/2020 0:00 12/31/2050 0:00 186 372077 Sam 5/16/2019 0:00 7/8/2020 0:00 186 239839 John 7/8/2020 0:00 12/31/2050 0:00 546 671357 Steve 5/14/2020 0:00 12/31/2050 0:00 thanks Sreejith
