List of values with filter, kindly help me!
Hi Team, Kindly help me for filter visual. I have the 'Data' column and categories columns. like below snapshot format. we required filter, If I select categories col of 'a' then "a" related all data shown like below snapshot. If select 'b' then "b" related of all data required. How to it in DAX with this? Note:- In power query it is possible, by splitting muliple cols and we will do it. but have performacne impact, kindly help me to it using DAX?
Filtering a table using TOP N slicer
Hi, i have a TOP N slicer which is a what if parameter from 0 to 50, i am trying to filter TOP N qty for a product in a table. please note there is already a TOPN filter on week for the table visual like pic below, so another topn is not possible and the data does not have an id/unique column and the products are repeted several times and the week in the sample is different from the topn loaddateweek. I am using a DAX measure to calculate the top products TOP N measure = VAR SelectedTop = SELECTEDVALUE('TOPN'[TOPN]) RETURN SWITCH(TRUE(), SelectedTop = 0, [Still to supply_sum], RANKX( ALLSELECTED(table[week],table[Product]), [Still to supply_sum], ,DESC,Dense ) <= SelectedTop, [Still to supply_sum] ) but this is not filtering for only 1 value when top n filter selected =1, but shows multiple value. Sample data is like below: Week Product Still to supply_sum rank 2024 34 6708 58720 1 2024 40 7706 64919 1 2024 38 6708 48120 2 2024 40 6708 43040 2 2024 38 731 34400 3 2024 36 6708 33560 3 2024 39 7448 36000 3 2024 41 6961 32040 5 2024 38 300 30080 6 2024 36 300 28120 7 2024 30 7551 24720 9 2024 41 122116010 22160 10 2024 36 731 21560 11 2024 41 7551 19790 15 2024 32 7551 19168 17 2024 31 300 16204 24 2024 32 300 15669 25 Not sure how to solve this issue to just have rank that does not repeat for a another row for the same product. Thanks for the help in advance.DAX query required for IF and IF Else condition of below case
Hi Team, I am new to PBI, help me with this case! IF type(col) = "AAA" & Date time(col) < 11AM then Pickup date = Date(col)-1 ELSE Pickup date = Date(col) IF type(col) = "BBB" then Pickup date = Date(col)–1 IF type(col) = "CCC" then Pickup date = Date(col) Value of "AAA" is having AAA_a, AAA_b, AAA_c, AAA_d, AAA_e ----AAA_n etc. So here we are calling the condition with "AAA". How do we calling "AAA" with one IF condition statement or any other. Same like value of "BBB" & Value of "CCC". Here date time(col) contains 24hrs, we required less than(< )upto 11AM then Pickup date = Date(col)-1, else Pickup date = Date(col). Here Date(col) is calculated column. So, kindly helpe me with the DAX query. below is the snapshot for your reference.
Printing content of web link in power bi table [ column] in one go
I have use case , A table has column mnamed LINK. it hold https link to a pdf content. there will be more rows in table with link as column. I am trying find solution to have button [ one click] does below. 1. Iterates all the links in LINK column 2. hit the link and get the PDF content one by one 3. Send the pdf to printer. How can i achieve this ?calculate time spent in each state
i have a data as given below Ticket num Created state Ticket_1 11/3/2022 0:06 P4 Ticket_1 11/3/2022 0:18 P4 Ticket_1 11/3/2022 0:21 P3 Ticket_1 11/3/2022 0:22 P2 Ticket_1 11/3/2022 0:23 P1 Ticket_1 11/3/2022 0:24 P1 Ticket_1 11/3/2022 0:26 P1 Ticket_2 12/12/2022 13:40 P1 Ticket_2 12/12/2022 13:41 P1 Ticket_2 12/12/2022 13:43 P2 Ticket_2 12/12/2022 13:45 P2 Ticket_2 12/12/2022 13:45 P4 Ticket_2 12/12/2022 13:46 P3 Ticket_2 12/13/2022 14:00 P1 i would now like to calculate time spent by each state in hours/seconds for every ticket in a 100% stacked bar chart and see the transition for state for Ticket_1 which changes from P4-->P3-->P2-->P1 Final chart to look something like this
Custom Comparison Filter
I want to create a way a user can select a drop down and you can compare the data based on current date range against what is selected. Similar to Google Data Studio. You can select to compare current date range vs. last period, last year or a custom date range you select. I feel like this is possible, using parameters but unsure. I would want to this with rates or calculated measures like CPM, CTR, CPC etc
achieving previous FY + 3 months of current FY in DAX
Hi friends, I need a DAX formula for my Custom Financial year. I would like to add a column showing: my financial year is 1st July 2022 - 30th June 2023 and dax formula should display: 1) if today's date is October or greater then show TRUE for dates falling within current financial year. 2) However, if today's date has recently entered a new financial period and current date falls within July, August, september (ie first 3 months of FY Period) then TRUE should display for dates falling within previous FY and up to dates within July, Aug, Sep of current financial year period. otherwise, false if neither of these conditions are met. Expected results if current month is August: FY Year Month Month Number Desired Result 2023/2024 2023 august 8 TRUE 2023/2024 2023 july 7 TRUE 2022/2023 2022 june 6 TRUE 2022/2023 2022 may 5 TRUE 2022/2023 2022 april 4 TRUE 2022/2023 2022 march 3 TRUE 2022/2023 2022 february 2 TRUE 2022/2023 2022 january 1 TRUE 2022/2023 2022 december 12 TRUE 2022/2023 2022 november 11 TRUE 2022/2023 2022 october 10 TRUE 2022/2023 2022 september 9 TRUE 2022/2023 2022 august 8 TRUE 2022/2023 2022 july 7 TRUE 2021/2022 2022 june 6 FALSE 2021/2022 2022 may 5 FALSE 2021/2022 2022 april 4 FALSE 2021/2022 2022 march 3 FALSE 2021/2022 2022 february 2 FALSE 2021/2022 2022 january 1 FALSE Expected results if current month is November: FY Year Month Month Number Desired Result 2023/2024 2023 november 11 TRUE 2023/2024 2023 october 10 TRUE 2023/2024 2023 september 9 TRUE 2023/2024 2023 august 8 TRUE 2023/2024 2023 july 7 TRUE 2022/2023 2022 june 6 FALSE 2022/2023 2022 may 5 FALSE 2022/2023 2022 april 4 FALSE 2022/2023 2022 march 3 FALSE 2022/2023 2022 february 2 FALSE 2022/2023 2022 january 1 FALSE 2022/2023 2022 december 12 FALSE 2022/2023 2022 november 11 FALSE 2022/2023 2022 october 10 FALSE 2022/2023 2022 september 9 FALSE 2022/2023 2022 august 8 FALSE 2022/2023 2022 july 7 FALSE 2021/2022 2022 june 6 FALSE 2021/2022 2022 may 5 FALSE 2021/2022 2022 april 4 FALSE 2021/2022 2022 march 3 FALSE 2021/2022 2022 february 2 FALSE 2021/2022 2022 january 1 FALSE Current script: Central_Calendar = ADDCOLUMNS( CALENDAR(DATE(2022,1, 1), DATE(2030,1,1)) , "Year", YEAR([DATE]) , "MonthNumber", MONTH([DATE]) , "Month", FORMAT([DATE], "MMM") , "Quarter", "Q " & FORMAT([DATE], "Q") , "QuarterNumber", FORMAT([DATE], "Q") , "Year Quarter", YEAR([Date]) & " " & "Q" & QUARTER([Date]) , "Year Quarter Sort", YEAR([Date]) & QUARTER([Date]) , "YearMonthNumber", FORMAT([DATE], "yyyy-mm") , "Month Year", FORMAT([DATE], "MMM YY") , "Month Year Sort", YEAR([Date]) *100 + MONTH([Date]) , "Fiscal Year", YEAR(EDATE([DATE], 6)) , "FY", "FY" & IF(MONTH([Date])<7, YEAR([Date])-1 & "/" & FORMAT([Date], "YY"), YEAR([Date]) & "/" & FORMAT(EOMONTH([DATE], 6), "YY")) , "Fiscal Month", MONTH(EDATE([DATE], 6)) , "Fiscal Quarter", QUARTER(EDATE([DATE], 6)) , "Fiscal Week", WEEKNUM(EDATE([DATE], 6)) , "Last 6 Months", IF(EOMONTH([DATE], 0) > EOMONTH(TODAY(), -6) && [date] <= TODAY(), TRUE()) , "Current_FY_to_Date", IF([DATE] >= DATE(YEAR(TODAY()) -1, 7, 1) && [DATE] <= TODAY(),TRUE(), FALSE()) , "Previous_FY", IF([DATE] >= DATE(YEAR(TODAY()) -2, 7,1) && [DATE] <= DATE(YEAR(TODAY()) -1, 6, 30),TRUE(), FALSE()) , "Previous_FY_Month", IF([Date] >= EDATE(TODAY(), -1) && [Date] <= EOMONTH(TODAY(), -1) && [DATE] >= DATE(YEAR(TODAY()) -1, 7,1), TRUE(), FALSE()) , "Previous_Month", IF([Date] >= EDATE(TODAY(), -1) && [Date] <= EOMONTH(TODAY(), -1), TRUE(), FALSE()) , "Current_FY_or Prev_FY_plus 2 months of current FY", IF ( AND( TODAY() >= DATE(YEAR(TODAY()), 7, 1), // Check if today's date is between July 1 of the current fiscal year TODAY() <= DATE(YEAR(TODAY()), 9, 30) // and September 30 of the current fiscal year ), OR( YEAR(EDATE([DATE], 6)) = YEAR(TODAY()) - 1, // Return TRUE for dates of the previous fiscal year [DATE] = DATE(YEAR(TODAY()), 9, 30) // Return TRUE for September 30 of the current fiscal year ), IF ( AND( TODAY() >= DATE(YEAR(TODAY()), 10, 1), // Check if today's date is between October 1 of the current fiscal year TODAY() <= DATE(YEAR(TODAY()) + 1, 6, 30) // and June 30 of the next fiscal year ), IF ( [DATE] >= DATE(YEAR(TODAY()) , 7, 1) && [DATE] <= TODAY() // Return TRUE for dates of the previous fiscal year to date TRUE(), FALSE() ), FALSE // Return FALSE if neither condition is met ) )) any suggestions on how to achieve this would be appreciated.Total of dax measure is blank, but it generates results in a table visual
the above shown code is my dax measure. This measures produces values for the respective BelegXPos when I use it in a table but doesn't show the grand total in the table and also shows up a blank when I use it in a 'Card' visual. Do you guys have any idea why could it be so..? Sample dataset is given below. Thanks a lot in advance. BelegXPos BUDAT WE BTE Menge0 A 09/09/1911 183 364 B 16/05/1924 171 147 C 18/09/1910 194 367 D 15/03/1920 109 215 E 24/03/1923 172 287 F 20/07/1920 150 341 A 19/08/1926 127 152 B 29/08/1925 170 340 C 19/11/1919 183 335 D 10/03/1922 154 136 E 19/08/1921 142 319 Total 1755 <Blank>Grand total of measure is blank
Hello community, I tried to write a measure to get the BTE1 column as my result. The problem is that I'm not getting the total for this column. the total is always a blank. I tried using this measure on a card or graph, everything seems to be blank but yet there are values in this measure when used in a table. The sample data is given in the table below: My measure is: BTE Menge1 = var last_Call = MAX('Data'[Call]) var Receipt= MAX('Quantity'[Receipt Nr.]) var Date= MAX('Quantity'[Date]) Return CALCULATE(SUM('Data'[qty]),'Data'[Receipt Nr.]=Receipt,'Data'[Date] IN {Date-1, Date, Date+1}, 'Data'[Call]=last_Call) Recipt Nr. Date WE BTE1 ABCD_10 20/04/2022 170 170 EFGH_10 15/07/2022 66 66 IJKL_10 28/07/2022 300 300 LMNO_10 31/10/2022 100 100 PQRS_10 31/10/2022 880 880 TUVW_10 04/08/2022 154 154 XYZA_10 11/11/2022 3000 3000 BCDE_10 10/03/2023 1650 1650 Total 6320 As info: the 2 tables are connected with a master data with receipt Nr. as key. can you guys please help me out and provide a solution as how to I can make the total on the BTE1 column visible? thanks a lot in advance!
