johnmow
11 years agoNew Member
Status:
Completed
Allow calculated measures that use Date/Time data format
I have a common requirement to show the "freshness" of my data in a report. Usually I create a calculated measure like MAX(CreatedDate) and expose it in a "ReadMe" page of my report. Current Power View does not even show these measures in the field list, Dashboard preview reports expose the measures but they fail when I try to use them in a table or on a card.
3 Comments
- saurabh_sharmaNew MemberDate measure is getting summed in Power BI.com datasets and not able to show data by date. Can you please help me with this
- katrina1New MemberHi, I am able to get the date measure to show in a card. However, I cannot change the date format. e.g. MaxTransactionDate = Max([txnDate]) returns 11/30/2015 12:00:00 AM Although the Data load states the Type to be "Date" and the country setting is on Australian English. It should come out as 30/11/2015. Thank you.
- fbcideas_migusrNew MemberStatus added:Completed
Recent ideas
Dynamic current-period defaults for separate Year and Month slicers
Scenario The target scenario is a report viewed in Power BI Service, using a DirectQuery semantic model and a dedicated Date dimension. Separate Year and Month slicers are part of the required user ...vvargasv2 days agoMicrosoft EmployeeNew13Views0likes0CommentsAbout "Download SQL database project" and fix the downloaded project
1. The sqlproj must be fixed, it is downloaded without the xml markup line <?xml version="1.0" encoding="utf-8"> 2. The sdk must be updated: Actual: <Sdk Name="Microsoft.Build.Sql" Version="0.1...Jarrinf2 days agoFrequent VisitorNew75Views3likes3CommentsAdd REST API to Take Ownership of Fabric Pipelines
When using service account to automatically deploy Fabric pipelines from Dev workspace to upper environments, the owner of pipelines in target envionment remain unchanged. In some situations, per...VickyPeng2 days agoRegular VisitorNew368Views5likes2Comments