Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Community,
I was trying to calculate last year month sales based on current year and month sales.
I have a Table 1 contains data from 2018-01-01 to 2019-04-31 with sales and
I have Table 2 contians data for 2019-04-31 with sales
Now my requirement is that I want to filter the table 1 for 2018-04-31 based on table 2 data.
Any help on this
hi, @Anonymous
You could SAMEPERIODLASTYEAR Function to add a measure:
https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax
Create a date table, then create a relationship with table1 and table2 as a bridge.
Best regards,
Lin
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
87 | |
79 | |
63 | |
61 | |
59 |
User | Count |
---|---|
166 | |
114 | |
99 | |
73 | |
65 |