Share
ReportHi,
I have a Dataverse Table which have 3 columns:
Month :WHOLE NUMBER field.
Year :WHOLE NUMBER field.
Month-Year :Single Line of Text field ; which is a calculated field with formula - Set Month-Year to Concat(Month,"-",Year)
In Canvas App, I have a dropdown of Month-Year field with below codes in Items Property :
Sort(Distinct(
Filter(
AgileMetrics,
(ProjectName.Name = cmbProject.Selected.Name && PortfolioName.Name = cmbPortfolio.Selected.Result)
),
'Month-Year'
),Result)
Here, cmbProject & cmbPortfolio are two other dropdown to select the value.. So Now we are getting data in below format:
1-2022
12-2022
3-2022
I need these data in Ascending Order , but I am not able to do so. PFA screenshot for the dropdown view.
Could you please help me on this?
Regards,
Abhradipa Banerjee
All responses (
Answers (
416
