User Profile
YavuzDuran
Helper III
Joined 5 years ago
User Widgets
Contributions
Expand Table
HI, I need a help for the following scenario. I have a table as shown in box 1 and I am trying to add the list of all Dates (column name will be "ActiveAssignedDates" after expanding the list) in between Previous & Last Assigned Dates for each Acct ID and Assignee. I used the following function, but did not help me: Table.AddColumn(#"Previous Step", "ActiveAssignedDates", each if [Start Date] = null then {Number.From([Last Assigned Date])..Number.From([Today])} else if [Last Assigned Date] > [Previous Assigned Date] and [Previous Assigned Date] <> null then {Number.From([Previous Assigned Date])..Number.From([Last Assigned Date])-1} else {Number.From([Last Assigned Date])..Number.From([Today]) } )Clicking on Tooltip is forwarding user to another page
Hi, When I click on a tooltip on the first page (first screenshot), it is forwarding me to the second page (second screen shot) and I created a different page for the tooltips on the first page, and setup for these tooltips is as the following: anyone can help me? Thank youPrevious Day's Numbers w/ Today's Numbers in the Same Table
I am trying to create a measure for Previous Days' numbers to put into the same table w the dates' numbers as you will see in the screenshot in red box. Where G4 =SUMIFS($D:$D,$B:$B,F4,$C:$C,"A")/SUMIF($B:$B,F4,$D:$D) Anyone who can help me? Unit No Date Category Amount Unit 1 1/15/2023 A 2,977.07 Unit 2 1/15/2023 B 4,926.79 Unit 3 1/15/2023 A 4,741.44 Unit 4 1/15/2023 A 2,881.64 Unit 5 1/15/2023 B 7,563.46 Unit 6 1/15/2023 C 8,255.05 Unit 7 1/15/2023 D 1,070.02 Unit 8 1/15/2023 D 9,137.65 Unit 9 1/15/2023 D 6,646.16 Unit 10 1/15/2023 B 4,274.56 Unit 1 1/16/2023 A 5,858.59 Unit 2 1/16/2023 B 488.41 Unit 3 1/16/2023 C 5,527.66 Unit 4 1/16/2023 C 6,886.18 Unit 5 1/16/2023 C 1,060.05 Unit 6 1/16/2023 D 5,714.39 Unit 7 1/16/2023 B 7,397.50 Unit 8 1/16/2023 C 5,734.51 Unit 11 1/16/2023 A 4,992.62 Unit 12 1/16/2023 B 3,346.84 Unit 13 1/16/2023 C 7,248.36 Unit 1 1/17/2023 D 2425.138 Unit 2 1/17/2023 A 7488.183 Unit 3 1/17/2023 D 5706.995 Unit 4 1/17/2023 A 6162.164 Unit 5 1/17/2023 A 1955.654 Unit 6 1/17/2023 B 4854.142 Unit 7 1/17/2023 B 5091.207 Unit 8 1/17/2023 C 3758.949 Unit 11 1/17/2023 C 4149.307 Unit 12 1/17/2023 C 5754.827 Unit 14 1/17/2023 B 7792.382 Unit 15 1/17/2023 B 8444.982 Unit 16 1/17/2023 B 145.6482Only and only last Month's numbers to be shown in column regardless of the date filter
Hi all, I want to show last month's numbers in colum: "IsRPC - Last Month", and regardless of the date/month I filtered that column should show always last month's numbers, should not change. As you will see below, IsRPC is September (selected month on the top slicer) numbers, but Last Month shows 0 I tried to use the following calculated column, but it does not serve the purpose: IsRPC - Last Month = if(and(CallLog2022[IsRPC]=1,and(year(today())=year(CallLog2022[DATE]),month(CallLog2022[DATE])=month(today())-1)),1,0) When I select Aug in Month Slicer, Last Month numbers show, as in below screenshotSome visuals are not showing the values (Table shows value in PBI Desktop but not in PBI Service)
Hi all I have the data and it show in the filters, as you will see in the screenshot below, but not in the table, and giving no error. When I refresh in Power BI Desktop table shows the values, but when I either publish it to service or refresh in Service the table shows NO value. I need help Thank you and here is the same table when I refresh in Power BI Desktop I have the data in the table
