Getting the last date without time
Hi, I'm creating a measure which shows the last date. I'm creating it with the following measure: 6_last_issue_date = maxx(table1, table1[issue_date].[Date]) It isn't clear in the picture but I'm using a card to show the date on. I get the next result: And I'm trying to get the next result: I don't know where he gets the time from, because in my modeling tab of the data i put it on a format without time : dd/MM/yyyy
Grouping dates into fortnights
Hi everyone, I'm looking for a solution that will help in grouping dates into fortnights, irregardless of month or year. I'll attach an image to help understand what I am meaning. It wouldn't matter if the column started at calendar start or a specific date. The date table I have is just an invoked funtion in M. Hopefully someone can help, I'm not sure what other information I could provide that would be helpful here.
IF value exists on calendar date
Hi everyone, i need help creating a measure that evaluates whether a value in on table exists at a particular date within the calender table . I am working with Two tables, on main table that has a customer and a purchase date. The second table is just a table showing the daily calendar dates. the outcome wanted is to evaluate whether a purchase was made by a customer at a certain date on the daily calender. the tables are as shown below : RESULT If a customer has purchased something on the date equivalent to the calendar date, return true, else false. as shown below: If anyone could assist me with writing a measure that could produce this outcome that would be wonderful 🙂 all help and sugegestions are welcome: Thank you
Dynamic target visual based on dates
Hello everyone, I am trying to to make a dynamic target visual based on dates. We have set some client targets per month, so every month we should have a certain amount of total clients. So the visual should jump to the next target after every month. I have a measure for active clients: Total active Clients = var __svym = TODAY() return CALCULATE(COUNT('Clients'[Client Code]), FILTER('Clients', __svym>='Clients'[Start Agreement] && __svym <= 'Clients'[End Agreement]) And I have a table with the targets and dates: Month & Year Target Clients 31 January 2020 1170 29 February 2020 1195 31 March 2020 1220 30 April 2020 1245 31 May 2020 1270 30 June 2020 1295 31 July 2020 1320 31 August 2020 1345 30 September 2020 1370 31 October 2020 1395 30 November 2020 1420 31 December 2020 1450 I have set the column Month & Year as data type 'Date' and I also have a date table. What measure or what syntaxis should I try to make this dynamic target visual possible? Please let me know your ideas, Kind regards RickReturn dates when condition is met
Hello Community! A few days I go I finished an Udemy course "Microsoft Power BI - Up & Running With Power BI Desktop" Now it's time to use that knowledge it in real life and life is brutal! I have a quite complicated task. I try to calculate kind of user efficiency rate like [quantity/hour] for example I baked 300 doughnuts in 20hours, it gives 15d/h or 1.1kg/h. 1.First I try to take dates from Table1 with code 111. 2.Then using those dates take GUIDs with action1. 3.Having GUIDs I can reach the properties like weight. In the end, the ratio SUM(weight)/SUM(hours) should be available for each user. Table1 Multiple users, codes and dates. USER CODE HOURS DATE User1 111 5 19.05 User2 001 4 19.05 User3 111 5 16.05 .... Table2 Multiple users, actions. . . USER ACTION Object_ID DATE User1 create guid1 19.05 User2 create guid1 19.05 User3 update guid2 16.05 .... Table3 unique GUIDs Object_ID weight property1 prop2.... guid1 w1 . . . . . . guid2 w2 . . . . . . guid3 w3 . . . . . . .... My post is dedicated to the first step. How to get dates from Table1 and use them as a filter to Table2? In which direction should I go, base only on measures, or new calculated tables? Or it's a too complicated task for PowerBI and I should shape the data with Python first? Kind Regards
