Share
Report
16Hi
I created a view screne to show my comments. I tried using this code that when a filter is selected from powerbi it should show comments related to it, it does it but the problem is when I select no filter like unselect from the filter in powerbi it doesnt show me all the comments in descending order recent one first as my date is in text data type due to a specific reason or it can do something like show me recent comments added in last 7 days.
My sharepoint file name is writebackcomments
The code is
If(
IsEmpty(PowerBIIntegration.Data) || IsBlank(LookUp(PowerBIIntegration.Data, true).OLD_CODE),
Sort(
Writebackcomments,
DATE,
SortOrder.Descending
),
Sort(
Filter(
Writebackcomments,
OLD_CODE = LookUp(PowerBIIntegration.Data, true).OLD_CODE
),
DATE,
SortOrder.Descending
)
)
Categories:
I have the same question (0)
All responses (
Answers (
