Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I have a Power query table with amounts sporadically spread across month/year dates, by User ID.
I then have a matrix (with a page filter by User ID) with fortnightly dates listed with amounts from measures created in DAX (these amounts display correctly).
I need to get the monthly amounts in the first table to display in the matrix without duplicating. It doesn't matter which date within a month the amount sits against, only that it displays only once.
I have tried many, many ways to achieve this but cannot get it to only display once.
Any help would be very appreciated 🙂
thank you
FYI
1. The closet I came to getting it to work was using an append table (of the 2 other sets of data i have) and the following measure (with the aggregation of the value set to Maximum):
2. I have also created a merged table that contains all sources of data (with an index) if that is more useful.
Solved! Go to Solution.
Given up trying to get the correct amounts displaying within the same table. I have just created another table that will display amounts based on slicer selections. not perfect but gives the required data.
Given up trying to get the correct amounts displaying within the same table. I have just created another table that will display amounts based on slicer selections. not perfect but gives the required data.
Hi @MLea ,
Please post a workable sample data that is not an image.
Proud to be a Super User!
Hi @danextian ,
sorry this is my first time posting a question. Do you mean replace the screen shots with 'tables' of data?
I can't attach the working file due to security/privacy issues.
You can just reply to my other post. Paste sample data from Excel to it or post a link to an Excel file in the cloud.
Proud to be a Super User!
Thank you for looking into my problem @Ashish_Mathur
The AA amount looks correct but the dates in the first column (under quarters) need to be the 'Amount_Post Date' as these dates are when the amounts are posted into the GL and the second column needs to be the 'Amount' column (being the amounts posted to the GL).
I need to match the assistant amounts by the month, while also accepting the page filter.
Hi,
Just ensure that your Calendar Table starts from 1/1/2023.
Hi, when the power bi file is connected to the actual data (not the sample I submitted) it will be for data over numerous years so the calendar start date can not be changed to 01/01/2023.
May be someone else can pitch in.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
105 | |
98 | |
38 | |
30 |