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.
I am trying to create a comparison file of data we use for budgeting. Comparing data that gets updated every month to the budget. We use LMC data to set our budget volumes, then need to compare the monthly updates of LMC against the budget volumes and LMC's previous' month data. I used the FILTER(CROSSJOIN(SELECTCOLUMNS) to compare Oct17 LMC to Budget LMC. Relationship through a date key table on date. Works fine. I create same FILTER(CROSSJOIN(SELECTCOLUMNS) to compare Nov17 to Budget LMC. Relationship through date key table on date. Fails. Nov17 provides 1 one number, appears to be a relationship issue but cannot solve.
Hi @pludlow,
It will be help if you share a pbix file/sample data to test.
Regards,
Xiaoxin Sheng
Hi, the data is under a license. So, I have to figure out a way to share the file if at all. thanks
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |