User Profile
PBI-Bro
Advocate II
Joined 6 years ago
User Widgets
Contributions
Re: Get Fabric Data Agents Running in Minutes – Fast, Easy, and For Everyone
This was a great guide to set up our first Data Agent. A word of caution: I had to add VERY specific instructions on how to interpret the measures because the agent kept adding its own interpretation. When asking for a KPI by year it kept on not using the start year of the campaign (as instructed) but would also filter on the year of the transaction. It took a lot of tweaking after this (and several other measures) started working as expected. Never share your Data Agents before you test them very thoroughly.2.1KViews0likes0CommentsRe: Number of donors by value, through time
I managed to sort out a calculation like this: High Donors = CALCULATE ( [Active Donors], FILTER ( ALL('Donor'), CALCULATE ( SUM('Transaction'[Amount]), DATESINPERIOD( 'Calendar'[Date], LASTDATE('Calendar'[Date]), -12, MONTH ) ) >= 500 ) ) Would you say this is the right approach? When I add the three categories as measures to my table it is taking a long time to calculate. Is there a better way to achieve this?703Views0likes0CommentsNumber of donors by value, through time
We need to create a table visualisation to display the following values by year and month (extendable to quarter and week): 1. Number of active donors 2. The Number of active donors split by their category. This category is based on the amount donated over the last 12 months. Donor category is defined as: 0-100 -> low 101 - 500 --> middle 500+ --> high The end result should look like this: Year Quarter Month Active Donors Low Middle High 2023 4 October 280 180 80 20 2023 4 November 310 200 100 10 2023 4 December 320 190 80 50 2024 1 January 120 90 20 10 For example: In October 2023 received donations from 180 donors who are categorized as "low" because their donations in the previous 12 months amounted to less than USD100. My model has the tables transaction, donor and calendar. Calendar hat a relationsihp to transaction and is marked as calendar table. I can calculate the number of active donors with this measure: Active Donors = VAR Result = CALCULATE ( COUNT('Donor'[DonorID]), FILTER( 'Transaction', 'Transaction'[Status] = "Booked" ) ) RETURN Result I am having trouble figuring out how to write measures to calculate the categories. I can calculate them for a static point in time but not in a way that they take the date categories into account. What should I look into? Thanks fory any help!Solved737Views0likes2CommentsRe: Data Colors Change in Service vs Desktop (different color priorities)
It's been five six years. I'm having a miserable morning because the colors of our brand new 2023 report suddenly are completely mixed-up and don't match any of the standards we use for other reports. Please. This really needs to be prioritized.1.3KViews0likes0CommentsRe: Can't calculate cumulative sum
Thank for your help. I decided to change the source data and add ispayday as boolean in the data warehouse. With the field imported into Power BI I used the following variation of your code and got the calculation working: Is Payday running total = VAR MaxDate = MAX ( 'Calendar'[Datekey] ) VAR Result = CALCULATE(COUNTROWS('Calendar'), 'Calendar'[Datekey] <= MaxDate && 'Calendar'[ispayday] = true ) RETURN Result833Views0likes0CommentsCan't calculate cumulative sum
Hi, I'm trying to do the simplest calculation here. A have a table with a Date Key column and a colum "IsPayday", which is of Type Whole number. I want to have a running total of the second one and have tried many variations of the formula below, but haven't figured it out: Thanks for your help!Solved903Views0likes4Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.