Need to create DAX for last 3 month visible in clustered column chart
Hi Experts, I want to create a dax to display the last 3 months when we select any month from the slicer. if not selected then it will display all month data in clustered column chart. Monthname is a slicer (MonthName = FORMAT([Date],"MMMM")) //text type Monthyear is a X axis in visual (MonthYear = FORMAT([Date], "MMM-yyyy")) //text type Tried this measure but no luck: Last3Months = VAR HasMonthSelected = ISFILTERED ( 'CustomCalendar'[MonthName] ) VAR EndDate = CALCULATE ( MAX ( 'CustomCalendar'[Date] ), ALLSELECTED ( 'CustomCalendar' ) ) VAR SelectedDate = MAX ( 'CustomCalendar'[Date] ) VAR Result = SWITCH ( TRUE (), HasMonthSelected && SelectedDate IN DATESINPERIOD ( 'CustomCalendar'[Date], EndDate, -3, MONTH ), 1, HasMonthSelected, 0, 1 ) RETURN Result Please help me on this. Thanks DK
Group by 2 columns
Hello, I need help. I've a table "saisie" and a table "places". In the table "places", I've a column that contain a count of records of table "saisie". This result give me the same value on each row and it's normal. Now I need to group this result by 2 columns of the table "places". How to do a group by 2 columns? Thanks for your help Regards
Change bar chart column for 3 higher value
Hi guys, I have a bar chart that represent risks. I want to change the color for the 3 higher risk where the value is the most elevated. I don't want to change color based to static value like >100 but by 3 top higher values of my chart How can i do this? Many Thx for helpYOY Growth starting from 100%
Hi Guys My team is preparing a Dashboard to demonstrate the YOY growth of the Net Fee Collected from different clients over the past 5 years. Since the dates are scattered in 3 different columns and cannot be filtered in one column we cannot use the time intelligence formulas. Therefore we have used the following revenue measures. 1. This Year NFC- TY NFC (In Lacs) = var MaxYear = MAX('Net Fee Collected'[Fiscal_Year]) //var year=[YTD] return CALCULATE(SUM('Net Fee Collected'[NFC YTD(In Lacs)]),FILTER('Net Fee Collected','Net Fee Collected'[Fiscal_Year] =MaxYear),FILTER('Net Fee Collected','Net Fee Collected'[Is CGP] = "Yes")) 2. Previous Year NFC- NFC_PY = var MaxYear = MAX('Net Fee Collected'[Fiscal_Year]) var PreviousFY = LEFT(MaxYear,4)-1 & "-" & RIGHT(MaxYear,4)-1 return CALCULATE([Total NFC],FILTER(ALLSELECTED('Net Fee Collected'),'Net Fee Collected'[Fiscal_Year] = PreviousFY)) 3. YOY growth %- YoY Growth % = DIVIDE(([TY NFC (In Lacs)]-[NFC_PY]),[TY NFC (In Lacs)]) YOY Growth % graph is automatically taking the stating year value as 100% growth. How can we make it 0%?
