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.
Hello all,
I have a query , I want data according to the selected values form calendar table, where calendar table should not be connected to the table from where data is to be taken,
example If I am selecting a particular quarter I want data according to the selected quarter without any measures for like calclulate(count('..'"))
what should I do ?
@Anonymous , Try like
measure =
VAR _max = MAXX(allselected('Date1'),'Date1' [Date])
var _min = MinX(allselected('Date1'),'Date1' [Date])
return
calculate(Sum(Table[Value]), filter(Table, Table[Date]>=_min && Table[Date]<=_max))
refer if needed
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
Thank you for the response, but I dont't want a measure with calculate /sum/count, because I dont want to create measures for each and every column, can it be directly made like just clicking on the slicer I would get the data without joining the tables
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 |
---|---|
117 | |
105 | |
69 | |
67 | |
43 |
User | Count |
---|---|
150 | |
103 | |
103 | |
88 | |
66 |