Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys!
I have three tables that i used to build of the measures.
Table 1 (Stores)
Field - First date of sales
Field - First ninety days ( First date of sales + 89)
Field - CNPJ (Code Store)
Table 2 (Ticket)
Field - Id Ticket
Field - created date
Field - CNPJ (Code Store)
Table 3 ( CNPJ Dimension)
Field - Distinct (CNPJ)
I need that a measure that make calcule with paremeters of date.
Example:
Store 1, First date of Sales (23/12/2020), First ninety days (22/03/2021)
Store 2, First date of Sales (03/12/2020), First ninety days (02/03/2021)
I want that measure make distinct count of tickets, where the result it s total of ticket (store 1 + store 2). It s possible?
I know that a calculated column would be possible, but I want to measure it.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
22 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |