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.
Hello People,
I am working on a dataset wherein I have Date, Category, Client Name, & Values as Columns,
Date is upto January to December, & i have added Week name column in this to get the week wise bifurcation, Values is updated once weekly, I want to search previous week, everyday and in which day the data is loaded , I want previous week that day data from today to be fetched.
I.e. Today is 04/04/2024 then my dataset will be having date from all 7 days but data will be present only in 1 day.
could anyone give me some advice on the way to do that in power query/ dax measure?
Thanks !!!
Hi @shubhamone8
try this below dax.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |