Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All ,
How to implement the below tableau logic in Power BI.
if OrderDate >= DATETRUNC('WEEK',TODAY()) AND OrderDate<= TODAY() then sum(sales) END
Here DATETRUNC('WEEK',TODAY()) ----> Will get the starting date of the week (9/10/2017)
TODAY()---> will get the today's date .
Thanks,
DK.
Solved! Go to Solution.
HI @dk_24,
You can use below formula to get the week start date.
WeekStart = [Date] + (1 - WEEKDAY([Date],1))
For your scenario, it will be modified like:
WeekStart = TODAY() + (1 - WEEKDAY(TODAY(),1))
Regards,
Xiaoxin Sheng
HI @dk_24,
You can use below formula to get the week start date.
WeekStart = [Date] + (1 - WEEKDAY([Date],1))
For your scenario, it will be modified like:
WeekStart = TODAY() + (1 - WEEKDAY(TODAY(),1))
Regards,
Xiaoxin Sheng
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |