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
dataflow
In the below scenario assume that D is the table I use in the report which is a append of 1, A and B. If I refresh DF1 and DF A then its obvious that the last dataflow would also refresh since it has 1 and A as linked entities. Questions: 1. Does the final dataflow refresh twice? 2. If I refresh 1 and A together will it cause the last one, and hence the entire chain to fail? Any best practices? 3. If I care most about A and expect 1 to fail often, how can I ensure that the final DF does not fail? And my append happens with A and B with the new data and 1 with the old data (in the current scenario the entire flow would fail)How to pass cell value as the Query value for a query utilizing Power Query
Good Morning, I am very green to Power Query, so I'm unsure if this is even possible. Base Goal: Pass the value from "SELECT_COL" as the UserQuery "let" statement. Clarifiying Details: I have 2 datasets 1) SURVEY_PARAMS 2) SOURCE_LKP_FILE I have successfully been able to filter down the SOURCE_LKP_FILE until I get just the 1 cell value "SELECT_COL" Code to get to just the query value I want to pass into the UserQuery(I can modify my SOURCE_LKP_FILE and add in or remove anything that's needed to help make this dynamic) below: let Source = SOURCE_LKP_FILE, #"Filtered rows" = Table.SelectRows(Source, each [TABLE_NAME] = "FOWLER_LKP_TBL"), #"Choose columns" = Table.SelectColumns(#"Filtered rows", {"SELECT_COL"}), #"Drill down" = #"Choose columns"{0}[SELECT_COL] in #"Drill down" I want to take the cell value from above and use it as part/whole of my UserQuery(my user query will just be a series of extract by range) I'm a heavy pipeline adf worker and I thought I'd be able to do some form of referencing within here like: let Source = SURVEY_PARAMS, #"Inserted text range" = $SELECT_COL in #"Inserted text range" Any help would be GREATLY appreciated
Parquet File Loading in Dataflow
Hi I tried loading parquet file from my OneDrive of size 200MB in power bi dataflow but it throw an error of Parquet.Document cannot be used with streamed binary values. It works well with parquet file of smaller size. I am attaching the screenshot with the error. is there any solution for this error?
