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.
Good night sir
I'm having trouble creating a measure, and I'm trying to simulate it in a DAX virtual table, I want that when it's between the 1st and 10th, take the sum of liters of fuel from the context, but from last month, p. ex, if it's November 5th, get October 5th, if it's 11th, get the sum of liters from 7 days ago, but it's returning empty, can someone help me understand what happens?
Solved! Go to Solution.
Good afternoon
I managed to solve the problem using the GENERATE function
Good afternoon
I managed to solve the problem using the GENERATE function
are you able to share your pbix or some data?
have you checked that you definitely have data for all the conditions? Also the relationship view of your model. How are these tables joined?
Proud to be a Super User!
User | Count |
---|---|
88 | |
88 | |
73 | |
67 | |
58 |
User | Count |
---|---|
136 | |
110 | |
91 | |
84 | |
69 |