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.
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
@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
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps