Forum Discussion
Dax formula error
Is I upload a file can you delete it after the solution?
Hey,
I'm sorry I got confused by the two measures in one code screen, sorry for that.
Please consider to create sample data, just an Excel file and a PBIX file. I will not download any file that I have to delete after I find a solution (if I ever will) or that you provide via a direct message.
Regards,
Tom
I'll send drop box link via private message.
Hey,
wondering if you read my last post carefully:
I will not download any file that that someone made available via direct message or that I have to delete on a certain condition, e.g. providing a solution.
Regards,
Tom
Apologies...Timing.
Just send private message...sorry
I deleted your private message without downloading
Cheers,
Tom
Can you confirm receipt. Also from the table that does not have sales date you'll need to create a month and year column to that data set. Or the sales table data set. Also as I was in a rush to create a sample file did not have time to label tables correctly- sorry.
The measure needs to calculate the sum of sales 12 months back from the selected date correct? Based on two slicers year and month..dynamically
Hi Tom..
silly question how do you attcahed a pbix file here....i can send a drop box link?
Hey,
just post the dropbox link!
regards,
Tom
1. the data in the link file you#ll need to chnage table name to dimdate and add a date hierarchy to the sales table....
also i have managed to get t his far - but the measure only gives me the current period 12 months rolling...
2. i want to show two visuals one in a clustered bar chart showing the previous 12 period and secondaly a card that dynamically changes to reflect the current month only...
Datefilter12Month = VAR MonthsToLookBack = 12 VAR DataTableDate = MAX ( 'DimDate'[Date] ) RETURN CALCULATE ( SUM ( Sales[Sales] ); DATESINPERIOD ( dimDate[Date]; DataTableDate; - MonthsToLookBack; MONTH ) )