Forum Discussion

itsmebvk's avatar
itsmebvk
Icon for Continued Contributor rankContinued Contributor
3 years ago

Date Column Date (UTC) to Localtime (AEST) Issue

  Hi Folks,   I am facing some date issue related to timezone.   I have a Date table (Azure analysis Service Model is source) in that table i have a Date column and other date related fields.  W...
Need Help
itsmebvk's avatar
itsmebvk
Icon for Continued Contributor rankContinued Contributor
3 years ago

 

 

H OwenAuger ,

 

Thanks alot for taking time and sharing your inputs.

 

Sorry I didnt understand how we need to filter on visual or page using the measure you suggested. New is the measure which i created, Can you please suggest what we need to filter here?

 

 

Thanks in advance.

 

OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
3 years ago

Hi itsmebvk 

No problem 🙂
Just to clarify, I was suggesting creating a Calculation Group and that code was for a Calculation Item within the Calculation Group.

 

See here for the general method to create these.

https://learn.microsoft.com/en-us/training/modules/dax-power-bi-calculation-groups/calculation-groups#task-3-create-a-time-intelligence-calculation-group

 

Once created, you can apply a filter on the column of the Calculation Group table for the specific Calculation Item.

 

Regards,

Owenn