Forum Discussion
Sort column by today's date
hi, Anonymous
"when i select month then the table should be replect data that of from the date 14 from that month"
what is the month do you select, and what is the date 14?
could you explain the output with the sample pbix file?
Best Regards,
Lin
Sorry! my Bad,
I mean i have data for last 12 months and i have merged them, i wish to filter visual according to month selection.
14 is the date of the each month or you can assume the 1st date of the each month for filter that month's data with upcoming lease expiring details, like you did this month's date "10/14/2019". but i am looking for results according to each month's 1st date.
or
do i need to add column date.firstdayofthe month instade of column "Today". and it should be in query editor.
What you think.
Hope i am clear on my query.
hi, Anonymous
It's not sure that I understood it correctly, do you want a date for slicer, then choose on date and use it as "Today" date in the measure?
If so, you could just use 'Fiscal Calendar'[Date] as a slicer and adjust the formula as below:
Measure flag = IF(DATEDIFF(SELECTEDVALUE('Fiscal Calendar'[Date],TODAY()),SELECTEDVALUE('data'[Lease End Date - Copy]),DAY)>=0,DATEDIFF(SELECTEDVALUE('Fiscal Calendar'[Date],TODAY()),SELECTEDVALUE('data'[Lease End Date - Copy]),DAY))note: 'Fiscal Calendar'[Date] must be a separate date table, if you need Fiscal Calendar create a relationship with data table, you need to change it with a separate date table.
Best Regards,
Lin
i wish to be filter data in power query. so i can work arround it