Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
142 | |
72 | |
62 | |
51 | |
48 |
User | Count |
---|---|
206 | |
90 | |
61 | |
59 | |
57 |