User Profile
NicholasJackson
Frequent Visitor
Joined 4 years ago
User Widgets
Contributions
Creating Reusable Date Filters
I have a simple measure that gets the total sales for the given year: Total Sales (YTD) = CALCULATE(SUM([Sales Amount]), DATESYTD('Calendar'[Date])) I have another measure where I would like to use the same date calculation, but instead use a different calculation: Total Orders (YTD) = CALCULATE(COUNTROWS('Sales'), DATESYTD('Calendar'[Date])) In this case, the filter calculation is quite simple as DATESYTD takes care of the heavy lifting. Copy/pasting the DATESYTD calcuation between measures isn't difficult or cumbersome. However, I have other date filters that are much more complex and need to be used in multiple measures. How can I create a reusable (date) filter to use on multiple measures? Few ideas: I could create a calculated table, but this seems like far too much overhead if I have 10+ date filters. This solution suggests creating a measure that simply has the filter criteria, but I'm afraid it may produce undesired results if used in the wrong context: https://community.fabric.microsoft.com/t5/Desktop/Creating-a-reusable-table-filter/m-p/1916927#M732781Solved1.1KViews0likes2Comments"The current row is too large to write" when copying to LakeHouse
I have a simple Gen2 Dataflow that copies data from an on-prem SQL server via the gateway to a lakehouse. When running the dataflow, I get this error message for all tables: Error Details: Error: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: The current row is too large to write. Details: GatewayObjectId: 7f52dde7-e378-4c36-8bcd-3edd76ac1a9e. Request ID: fb4b7dc8-c61c-9ae8-ad30-cf818125c796. (Request ID: 18fa9c00-6122-47c7-8a8a-50c7e88c457c). The data I'm trying to pull is very small, sometimes only 3 columns and 2 rows. What could be causing this issue?3.8KViews3likes10Comments
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.