Forum Discussion
To show the data for current day
Hello, I want to show the present day data(Today's data). So I created a calculated column as below and given a visual level filter as AsofToday is 0. AsofToday = DATEDIFF(DATEVALUE(FactTable...
You could try modifying your formula a bit such as:
AsofToday = IF(DATEDIFF(DATEVALUE(FactTable[Date]),DATEVALUE(TODAY()),DAY)=0,"today","not today")
And then just change your filter criteria, might clear up the zero vs. blank problem.
Hi,
I have a Virtual Machine environment in Pacific time zone.
In the morning when I access my VM(I am located in India), and if I refresh my power bi reports I get blank values for data for As of Today. I created measure for todays date(Today = TODAY()) and displayed using score card visualization. Its showing IST time even though we are accessing powerbi.com in VM.
Can I change the time zone in power.com?