Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
This is how the table binding looks like:
I would like to create a measure that will calculate daily increase/decrease in the column: sessions_info[instagram_profiles_info.followers] for each sessions_info[date]
there may be several entries for the sessions_info[date] , therefore the maximum value should be taken for each date.
another problem is that this table sessions_info has records for all profiles in instagram_profiles. and I need to plot the change for each one based on the slice selection in my visualization. slicer based on instagram_profiles[name]
dailychange =
VAR yesterday=maxx(FILTER(all(sessions_info),sessions_info[Date]=SELECTEDVALUE(sessions_info[Date])-1),sessions_info[instagram_profiles_info.followers])
return if(ISBLANK(yesterday),BLANK(),max(sessions_info[instagram_profiles_info.followers])-yesterday)
this is my attempt to build but it doesn't work properly.
Solved! Go to Solution.
please see the attachment below
Proud to be a Super User!
maybe I did not describe it well enough.
the measure I wrote works, but only when the sessions_info table contains data for one profile. then there is simply no need to filter and the measure calculate for all the lines.the problem occurs when I have data from other profiles. then the measure simply scrambles the data.
@ryan_mayu I think you helped me, but now the data structure has changed, and i have data for multiple profiles in one database
since I am not clear about your real business, could you pls provide some sample data and expected output?
Proud to be a Super User!
please see the attachment below
Proud to be a Super User!
@ryan_mayuThank you,thats it. i added one modification because for the first day in the model this column always returned a big jump (because your column in this case assumes yesterday was 0). so I added a simple if condition
glad to hear that.
Proud to be a Super User!
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |