Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi! I have been trying to figure out a way to find the difference betweem A/R aging buckets in my Power BI report where I have 2 files in the Folder Data Set. I want to be able to do a comparison between each aging bucket by comparing it to the file that was ran at the end of month (EOM). When I created the data source I created a column based on the source name and the colume A/R Aging Date will either say Current (for the most recent file) or EOM (for the previous months data). If you see the example below, how I can compare the < 31 values, and each bucket after that? Any guidance is appreciated.
@jdobbins , Need raw data for that. Assume you have measures that works across buckets and datset.
If these files are merge in power bi and current and EOM are row values
then you can have measures like
calculate([Measure], filter(Table, table[file name] = "Current")
or
calculate([Measure], filter(Table, table[file name] = "EOM")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
95 | |
94 | |
80 | |
71 | |
64 |
User | Count |
---|---|
115 | |
106 | |
96 | |
81 | |
72 |