WebbThis is the result. I thoght it worked but no it is missing the data of Jan 2024. Now to fix this issue i need to change the query. Last 5 Qs flag = IF (DATE (YEAR ( [Date]),MONTH ( [Date]),1) >= DATE (YEAR (TODAY ()),MONTH (TODAY ()) -15, 1), 1, 0) so now i need to change 14 to 15. because i moved to Q2. This is ok but not a feasible solution ... Webb14 apr. 2024 · CALCULATE ( [YourSalesMeasure], FILTER ( ALL ( 'DateTable' ), DateTable [Year] = YEAR ( TODAY () ) - 1 && DateTable [Date] <= TODAY () ) ) If this answer solves your problem, give it a thumbs up and mark it as an accepted solution so the others would find what they need easier. Regards, Loran Message 2 of 14 174 Views 0 Reply JDU …
Cloud Data Platform Weekly - LinkedIn
Webb11 apr. 2024 · Power BI allows you to set up push notifications for specific errors, so you can be notified even when you’re not actively using the application. Here’s how to set up push notifications in... WebbI'm a Business Intelligence Developer and Data Analyst certified in Power BI who is interested in building up-to-date BI solutions (particularly with … hr in tcs
Power BI Date or Calendar Table Best Method: DAX or Power …
Webb13 apr. 2024 · Power BI Service Workspace UI Change - hard to use. Hi, Has anyone else had an update to the Service Workspace UI? -The filter for Objects does not save so when you go into a report and then back into the workspace you are given a massive colourless list of objects again, and have filter through a drop down everytime. WebbMissing data refresh option. 10m ago. Hello, I used to be able to go to the hamburger on my reports, "view data set" and refresh the data manually from there. However, today, the options are gone. Anyone else experienced this? Webb6 apr. 2024 · Calculate with dates (30 days before) I need to do a measurement that … hoarder forza horizon 5