Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi every one,
I have a report showing 3 days operation, yesterday, Today, and tomorrow, but the on Sunday the bigging of the week I need this report to show Thursday, Friday, and Saturday, and this is only on sunday
Can someone advise how to do this??
this what I have done so far:
if [Oper.Date UTC] = DateTime.Date(DateTime.LocalNow()) then "Today"
else if [Oper.Date UTC] = DateTime.Date(Date.AddDays(DateTime.LocalNow(),-1)) then "Yesterday"
else if [Oper.Date UTC] = DateTime.Date(Date.AddDays(DateTime.LocalNow(),+1)) then "Tomorrow"
else if [Oper.Date UTC] = DateTime.Date(Date.AddDays(DateTime.LocalNow(),-2)) and [Oper.Date UTC] = Day.Sunday then "Friday"
else if [Oper.Date UTC] = DateTime.Date(Date.AddDays(DateTime.LocalNow(),-3)) and [Oper.Date UTC] = Day.Sunday then "Thursday"
else null
Solved! Go to Solution.
Use this
= if Date.DayOfWeekName(DateTime.Date(DateTime.FixedLocalNow()))="Sunday" and Date.From([Oper.Date UTC]) = DateTime.Date(Date.AddDays(DateTime.LocalNow(),-1)) then "Saturday" else
if Date.DayOfWeekName(DateTime.Date(DateTime.FixedLocalNow()))="Sunday" and Date.From([Oper.Date UTC]) = DateTime.Date(Date.AddDays(DateTime.LocalNow(),-2)) then "Friday" else
if Date.DayOfWeekName(DateTime.Date(DateTime.FixedLocalNow()))="Sunday" and Date.From([Oper.Date UTC]) = DateTime.Date(Date.AddDays(DateTime.LocalNow(),-3)) then "Thursday" else
if Date.DayOfWeekName(DateTime.Date(DateTime.FixedLocalNow()))<>"Sunday" and Date.From([Oper.Date UTC]) = DateTime.Date(DateTime.LocalNow()) then "Today" else
if Date.DayOfWeekName(DateTime.Date(DateTime.FixedLocalNow()))<>"Sunday" and Date.From([Oper.Date UTC]) = DateTime.Date(Date.AddDays(DateTime.LocalNow(),-1)) then "Yesterday" else
if Date.DayOfWeekName(DateTime.Date(DateTime.FixedLocalNow()))<>"Sunday" and Date.From([Oper.Date UTC]) = DateTime.Date(Date.AddDays(DateTime.LocalNow(),+1)) then "Tomorrow" else
null
Use this
= if Date.DayOfWeekName(DateTime.Date(DateTime.FixedLocalNow()))="Sunday" and Date.From([Oper.Date UTC]) = DateTime.Date(Date.AddDays(DateTime.LocalNow(),-1)) then "Saturday" else
if Date.DayOfWeekName(DateTime.Date(DateTime.FixedLocalNow()))="Sunday" and Date.From([Oper.Date UTC]) = DateTime.Date(Date.AddDays(DateTime.LocalNow(),-2)) then "Friday" else
if Date.DayOfWeekName(DateTime.Date(DateTime.FixedLocalNow()))="Sunday" and Date.From([Oper.Date UTC]) = DateTime.Date(Date.AddDays(DateTime.LocalNow(),-3)) then "Thursday" else
if Date.DayOfWeekName(DateTime.Date(DateTime.FixedLocalNow()))<>"Sunday" and Date.From([Oper.Date UTC]) = DateTime.Date(DateTime.LocalNow()) then "Today" else
if Date.DayOfWeekName(DateTime.Date(DateTime.FixedLocalNow()))<>"Sunday" and Date.From([Oper.Date UTC]) = DateTime.Date(Date.AddDays(DateTime.LocalNow(),-1)) then "Yesterday" else
if Date.DayOfWeekName(DateTime.Date(DateTime.FixedLocalNow()))<>"Sunday" and Date.From([Oper.Date UTC]) = DateTime.Date(Date.AddDays(DateTime.LocalNow(),+1)) then "Tomorrow" else
null
Thanks for your help
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
User | Count |
---|---|
16 | |
14 | |
8 | |
8 | |
7 |